SUBTOTAL A LIST

[Jim W]

Hi - Is there a way to subtotal a list...once I create a list the subtotal
feature is not available. I also fail to see the difference between a list
and the auto filter function, can someone explain?
Thanks,
Jim

 

[Huber57]

Jim,

Here is the technique that I use. Insert some lines above the headers in
your spreadsheet.

Example:
Row 1
Row 2
Row 3
=SUBTOTAL(9,D61000)
Row 4
Row 5 First Name Last Name Sales Region Sales ($)
Etc

Lets say you want to filter just the midwest sales regions sales total.
Use the Subtotal function =SUBTOTAL(9,D61000) (this will sum all the sales
figures in the sales column). Now if you filter Sales Region it will sum
only the cells not filtered out.

For more info on the subtotal function, click here:
http://www.ozgrid.com/Excel/excel-subtotal-function.htm

HTH

 

[Gord Dibben]

No way to subtotal a List created with Data>List>Create List.

For benefits of using List see help on "about list features."


Gord Dibben MS Excel MVP