P Peo Sjoblom Apr 2, 2006 #2 Have you tried the SUBTOTAL function (not Data>subtotal)? SUBTOTAL(9,Range) will sum visible cells -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
Have you tried the SUBTOTAL function (not Data>subtotal)? SUBTOTAL(9,Range) will sum visible cells -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
G Gord Dibben Apr 2, 2006 #3 Frank =SUBTOTAL(9,A1:A1000) will return the SUM of filtered data. See SUBTOTAL Function for more options like counting, averaging and others. Gord Dibben MS Excel MVP
Frank =SUBTOTAL(9,A1:A1000) will return the SUM of filtered data. See SUBTOTAL Function for more options like counting, averaging and others. Gord Dibben MS Excel MVP
