use autofilter command and filter the rows. then go to the last row and click the cell where u need the total and pres alt+=. this will trigger subtotal command u will be able to view only sum of filtered rows
Dave wrote:
EXCLUDE TOTAL FROM FILTER
13-Oct-09
Hi
I am trying to create a row which will only sum whatever is in a filtered
columns.
Can this be done??
Previous Posts In This Thread:
EggHeadCafe - Software Developer Portal of Choice
Secure Session State Transfer: ASP to ASP.NET
http://www.eggheadcafe.com/tutorials...tate-tran.aspx