=SUBTOTAL(9,A2:A1000)

see help for other options like count, average etc all part of the SUBTOTAL
function

--


Regards,


Peo Sjoblom

"John" wrote in message
...
I am trying to get the sum of filtered data. Just adding each cell for
data
in column F when I auto filter the data????