Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I see the need to use 101-111 for Subtotals; e.g. I want to ignore hidden
values. But, I don't see why I want to use Subtotals 1-11, instead of using the built-in functions like average, count, max etc. directly. I do understand that if I use DataSubtotals, I can later modify the Subtotals function which may have 1-11. Please enlighten me. Why would I choose Subtotals 1-11 over a more direct method? Am I missing something obvious? Thanks. Epinn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make subtotals appear directly below groups with spaces b | Excel Discussion (Misc queries) | |||
Can I do this with built in functions? | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
pivot table, functions for subtotals | Excel Worksheet Functions |