Subtotal function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What does the number mean in the subtotal function.

Any help with this would be great

Melani
 
Subtotal is used to perform statistical functions on a filtered list
the number part determines which function it does - e.g.

If you have a table with sales of ice cream day by day and you want t
look at average sales for mondays

Using autofilter you set select the entries for Mondays

=subtotal(1,sales) would give the average ice cream sales for mondays
Changing the filter would give tuesdays or wednesdays etc. A full lis
of the available subtotal functions can be found in Hel
 
You must log in or register to reply here.

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

Conditional SUBTOTAL in XL210 Table 7
Copy within a subtotal 1
Subtotal placement issue 2
countif in a subtotal function 1
SUBTOTAL function 3
Subtotal function for text 3
Subtotal To Include Item Description On Subtotal Line 2
Getting Text data using the Data - Subtotal feature 1

Back
Top