ExcelBanter - Formula question

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula question (https://www.excelbanter.com/excel-discussion-misc-queries/114589-formula-question.html)

Heather

Formula question

=SUBTOTAL(9,D61:D62)

What does the 9 mean in this equation?

CLR

Formula question

The 9 invokes the SUM function.

Here's the list from HELP.

Function_Num Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

hth
Vaya con Dios,
Chuck, CABGx3

"Heather" wrote:

=SUBTOTAL(9,D61:D62)

What does the 9 mean in this equation?

All times are GMT +1. The time now is 10:41 AM.