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

  • Thread starter Thread starter TransMan
  • Start date Start date
T

TransMan

How does this work. =SUBTOTAL(109,[YTD Actual]), I can't get it to work.
 
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
 
=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Question 8
Summing only #'s on unhidden columns 2
subtotal with sumif nested 1
Average of Subtotals in Pivot Table 0
Subtotal percents in pivot table 1
Sum visible negative cells using formula 4
nesting sumproduct with subtotal 9
Need array formula to ignore hidden values 1

Back
Top