Subtotalling

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

Guest

I am not a new user, but I have a question that might be basic about formulas.
This is the formula that appears when I select Data, Subtotals for my
worksheet.
=SUBTOTAL(9,E2:E1201)

It is the formula in the Grand Total Cell. Can you tell me what the 9,
contained within the parenthesis means? Does that mean it only looks that
the subtotals when calculating the Grand Total?
 
Ann,

Click onto the fx just above the B column and enter subtotal.

Then click onto "help on this function " in the left hand bottom corner of
the pop-up window.
The next help screen will show you a list of all the variations of subtotals

#2 is count
#9 is sum
etc
 
9 = sum specified range, including hidden rows
109 = sum visible rows only

In either case, if a filter has been applied to the range, SUBTOTAL only
operates on the results of the filter.

SUBTOTAL also ignores any nested Subtotals within the range.

A complete list of available options for SUBTOTAL() is in it's Help entry.
(1 and 101 for AVERAGE(), 2 & 102 for COUNT(), etc.)


HTH,
 
Back
Top