Share via

What does the "9" mean in auto sum formula?

Anonymous
2012-05-02T13:11:33+00:00

For example, to show the total of everything in column "A",  I use Auto Sum on the tool bar & the forumla appears like this:

=SUBTOTAL(9,A:A)

There are no problems with the formula working - - I've just always been curious as to why the number 9 always appears automitically & what it does.  Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-05-02T13:23:59+00:00

    Hi,

    The autosum button should use the SUM formula, in this case =SUM(A:A).

    Whatever button/menu option you're using is using the SUBTOTAL function. this function has 2 arguments. The first; 9 in this case means SUM and the second is the range. Other argumenst are pasted below and can be found in Excel help for Subtotal.

    As you can see from below 9 is SUM and 109 is SUM but ignore hidden values.

    1 101 AVERAGE
    2 102 COUNT
    3 103 COUNTA
    4 104 MAX
    5 105 MIN
    6 106 PRODUCT
    7 107 STDEV
    8 108 STDEVP
    9 109 SUM
    10 110 VAR
    11 111 VARP

    40+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-05-02T13:21:52+00:00

    If you use autofilter

    then the 9 'summarize' visible cells.

    (NOT, to hide rows)

    7 people found this answer helpful.
    0 comments