How do I set criteria to sum only on filtered amounts?
G Gord Dibben Nov 27, 2006 #2 =SUBTOTAL(9,A:A) will Sum the visible cells in column A Gord Dibben MS Excel MVP
G Gord Dibben Nov 27, 2006 #3 Ammendment.......... Visible due to filtering only. If you are running 2003 version, to sum visible cells that are due to hiding rows and/or filtering use =SUBTOTAL(109,A:A) Gord
Ammendment.......... Visible due to filtering only. If you are running 2003 version, to sum visible cells that are due to hiding rows and/or filtering use =SUBTOTAL(109,A:A) Gord
