Is there a way to have Excel give totals for filtered data automatically when
I filter the data?

I like to put my totals in row 1, my headers in row 2 and my data in rows 3:xxx.

Then I can use =subtotal(#,xx:xx) in row one to get those nice subtotals.

And =subtotal() will ignore those rows hidden by an autofilter.

Skeeve1313 wrote:

Is there a way to have Excel give totals for filtered data automatically when
I filter the data?

--

Dave Peterson

Hi

Another way is to select the column for summing and, when the filter is
applied, the total can be read in the status bar at the bottom right (or the
average, count, etc) automatically. Change the filter, and the total
changes.

Andy.

"Dave Peterson" wrote in message
...
I like to put my totals in row 1, my headers in row 2 and my data in rows
3:xxx.

Then I can use =subtotal(#,xx:xx) in row one to get those nice subtotals.

And =subtotal() will ignore those rows hidden by an autofilter.

Skeeve1313 wrote:

Is there a way to have Excel give totals for filtered data automatically
when
I filter the data?

--

Dave Peterson