Sum after Filter, Count after Fliter

  • Thread starter Thread starter Jimmie
  • Start date Start date
J

Jimmie

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!
 
Subtotal doesn't work because once I change the filter the value of the
subtotal changes. any help would be greatly appreciated. happy holidays!
Click to expand...
Sure it does, check the help for SUBTOTAL
 
Subtotal doesn't work because once I change the filter the value of the
subtotal changes. any help would be greatly appreciated. happy holidays!
Click to expand...

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?
 
Back
Top