J John Oct 20, 2008 #1 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????
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????
P Peo Sjoblom Oct 20, 2008 #2 =SUBTOTAL(9,A2:A1000) see help for other options like count, average etc all part of the SUBTOTAL function -- Regards, Peo Sjoblom
=SUBTOTAL(9,A2:A1000) see help for other options like count, average etc all part of the SUBTOTAL function -- Regards, Peo Sjoblom
M Max Oct 20, 2008 #4 Try in say, G1: =SUBTOTAL(9,F:F) -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik
Try in say, G1: =SUBTOTAL(9,F:F) -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik
