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

=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????

Look at the SUBTOTAL function in help.

--
__________________________________
HTH

Bob

"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????

Try in say, G1: =SUBTOTAL(9,F:F)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"John" wrote:
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????