Geting sum totals when using a filter.

mrowe · Feb 22nd, 2002, 04:57 AM

Hi,
I'm aware there is a way of using sum totals when the autofilter is applied, but can't remember how to do it - can you help?

Also
the list from which the the sum total drops down a row each time a new entry is added, how can I get the sum to include the new cell from the row in the range so it calculates correctly.

Many Thanks

Feb 22nd, 2002, 06:42 AM

Use the subtotal function

=SUBTOTAL(9,[RANGE])

9 denotes the sum function. There are many others for count, average yaddy yaddy yadda (see help for a full list)

James

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 04:57 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Hi, I'm aware there is a way of using sum totals when the autofilter is applied, but can't remember how to do it - can you help? Also the list from which the the sum total drops down a row each time a new entry is added, how can I get the sum to include the new cell from the row in the range so it calculates correctly. Many Thanks

Feb 22nd, 2002, 06:42 AM	#2
Guest Posts: n/a	Use the subtotal function =SUBTOTAL(9,[RANGE]) 9 denotes the sum function. There are many others for count, average yaddy yaddy yadda (see help for a full list) James