Editor’s Note: To read more about spreadsheets, share a tip with other readers, or suggest a topic for Bill Jelen to cover in an upcoming column, click here to visit CFO.com’s Spreadsheet Tips Page.

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

I have set-up a pivot table to analyse staff absences by type and dept - columns for the type and rows for name within department. The 'data' is then the number of days absence by type. How do I total ...

I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...

In conditional formatting, formula, I am using an Excel hack to automatically highlight the "total" rows in a pivot table, namely... In setting up the formula I apply ...

How to display multiple subtotal rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and display ...

The result is The sum is 100 which is the total of lines in the test excel file (reduced of the original). After I uncheck and check the value "PageCount" the correct totals are shown. (242 printed ...

If you want to know how to use VLOOKUP to sum multiple rows in Excel, we’ve got you covered. VLOOKUP's syntax only returns the first value in a column. However, if you have data where values are ...