Sum of filtered data

[John]

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

 

[Peo Sjoblom]

=SUBTOTAL(9,A2:A1000)

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

--


Regards,


Peo Sjoblom

 

[Bob Phillips]

Look at the SUBTOTAL function in help.

 

[Max]

Try in say, G1: =SUBTOTAL(9,F:F)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik