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!