Why use Subtotals 1-11 instead of the built-in functions directly?

  • Thread starter Thread starter Epinn
  • Start date Start date
E

Epinn

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 Data>Subtotals, 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 said:
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 Data>Subtotals, 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
Click to expand...
Remember we can't see your spreadsheet. The above question can't be
answered with the info you provided.

gls858
 
Epinn said:
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 Data>Subtotals, 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
Click to expand...

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.
 
Remember we can't see your spreadsheet. The above question can't be
answered with the info you provided.
Click to expand...

Why do you need a spreadsheet? This is a **general** question to understand
a theory/concept. I have already cited my understanding below. I am asking
for examples as to why I want to use one method over the other. Anyone else
who understands what I am asking, please feel free to contribute.

Thanks.

Epinn
 
Subtotals will ignore rows that have been filtered via
Data>Filter>Autofilter

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Leo,

Thank you so much. You told me exactly what I needed to know but missed.

The help feature talked about 1-11 including hidden values as a result of
format>row>hide but it had no mention of data hidden as a result of
**AutoFilter**.

What a subtle difference that can cause dramatically different effect!

Your help is much appreciated.

Cheers,

Epinn
 
You're welcome, Epinn.
Thanks for the feedback!

You're right about "Help". It's not very clear
in this situation.
 
Back
Top