Why use Subtotals 1-11 instead of the built-in functions directly?
"Epinn" skrev i en meddelelse
...
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
Epinn
The important difference between Subtotal 1-11 and Subtotal 101 - 111 is,
that Subtotal 1-11 do not work on rows *hidden by filtering*, while
Subtotal 101 - 111 don't work on *any* hidden row (hidden by filtering OR
hidden manually).
The built-in functions you mention works on all rows, hidden or visible.
--
Best regards
Leo Heuser
Followup to newsgroup only please.
|