| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I choose multiple items from a drop down box? | Excel Worksheet Functions | |||
| Choose date from drop-down calendar | Excel Worksheet Functions | |||
| How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
| Drop Down Box to Choose Time | Excel Discussion (Misc queries) | |||
| How do I choose multiple values in a drop down box? | Excel Discussion (Misc queries) | |||
Linear Mode
