Sum after Filter, Count after Fliter
 

I am using excel 2003
I have a list of filtered data and I want to count the total rows after
filtered and also sum the total amount. When I type '=SUM(then select the
range),' it will sum all of the hidden cells inbetween. same for the COUNT
function. instead of giving the total of '26' cells it selects those
inbetween for a total of '616.'

when I highlight the cells with the mouse, the bottom status bar gives the
correct count, sum, average, min, max, which is all the data that i'm looking
for. how do i transfer that data to my workbook?

Subtotal doesn't work because once I change the filter the value of the
subtotal changes. any help would be greatly appreciated. happy holidays!

Sum after Filter, Count after Fliter
 

Subtotal doesn't work because once I change the filter the value of the
subtotal changes. any help would be greatly appreciated. happy holidays!
Sure it does, check the help for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jimmie" wrote in message
...
I am using excel 2003
I have a list of filtered data and I want to count the total rows after
filtered and also sum the total amount. When I type '=SUM(then select the
range),' it will sum all of the hidden cells inbetween. same for the COUNT
function. instead of giving the total of '26' cells it selects those
inbetween for a total of '616.'

when I highlight the cells with the mouse, the bottom status bar gives the
correct count, sum, average, min, max, which is all the data that i'm
looking
for. how do i transfer that data to my workbook?

Subtotal doesn't work because once I change the filter the value of the
subtotal changes. any help would be greatly appreciated. happy holidays!

Sum after Filter, Count after Fliter
 

Subtotal doesn't work because once I change the filter the value of the
subtotal changes. any help would be greatly appreciated. happy holidays!

Isn't that exactly what you want? It should change when you change the
data. The status bar uses the Subtotal function, so it should match.
Maybe you've got an error in the formula?