how to use subtotal and it has a drop down to choose other functi
 

How does this work. =SUBTOTAL(109,[YTD Actual]), I can't get it to work.

how to use subtotal and it has a drop down to choose other functi
 

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


"TransMan" wrote in message
...
How does this work. =SUBTOTAL(109,[YTD Actual]), I can't get it to work.

how to use subtotal and it has a drop down to choose other functi
 

=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

On Tue, 15 Apr 2008 18:04:00 -0700, TransMan
wrote:

How does this work. =SUBTOTAL(109,[YTD Actual]), I can't get it to work.