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

T

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

=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
 

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

How to make repeating drop-down lists? 2
Subtotal percents in pivot table 1
Summing only #'s on unhidden columns 3
Drop down list control value in vba 2
How to paste this down? 3
nesting sumproduct with subtotal 9
Drop down lists in seperate columns 5
Subtotal of values in cells containing formula 1

Top