Total on filter
Hi,
Could you give me an example since my totals are on the F column and when i
use the sumtotal function i receive a circular reference error???? I am using
excel 2002/sp3. I do not receive the total results in either filtered or
unfiltered mode.Is there something i am missing?
Thanks for the support
"Gord Dibben" wrote:
Use the SUBTOTAL function.
=SUBTOTAL(9,B:B) which includes filtered and hidden values.
Or in 2003 version
=SUBTOTAL(109,A:A) which ignores hidden values.
Gord Dibben MS Excel MVP
On Thu, 6 Jul 2006 19:10:02 -0700, jk wrote:
Hi,
I have a sheet which contains many accounts in one column and amounts paid
in another column,I really dont need the auto filter which places a filter on
every column.How do you make a filter for the account column and at the same
time have a total for the amounts paid column when the filter shows only
those accounts?
|