T Tyro Apr 16, 2008 #2 If your table name is YTD then =SUBTOTAL(109,YTD[Actual]) You should just point to the table and select the column(s) and let Excel complete the formula for you. Tyro
If your table name is YTD then =SUBTOTAL(109,YTD[Actual]) You should just point to the table and select the column(s) and let Excel complete the formula for you. Tyro
G Gord Dibben Apr 16, 2008 #3 =SUBTOTAL(109,range) will SUM only the visible cells in a filtered range and also exclude any hidden cells. =SUBTOTAL(9,range) will SUM visible cells in a filtered range and include hidden cells. Gord Dibben MS Excel MVP
=SUBTOTAL(109,range) will SUM only the visible cells in a filtered range and also exclude any hidden cells. =SUBTOTAL(9,range) will SUM visible cells in a filtered range and include hidden cells. Gord Dibben MS Excel MVP
