more about totals...

This function allows you to subtotal data in the column, based on a change in another column.

You can choose one column on which to base your subtotals (let's say Column A), and another column (Column B) with values to be summarized. Run the query and the result will appear as a table of unique values for column A and sums of values for column B.

We want you to find this page by the following keywords:

^{excel subtotal, get totals, free excel functions, excel tutorial, subtotal function, data list, subtotal in column, Excel help, xls tips and tricks, Excel formulas, functions, VBA}