Could someone tell me what the 9 represents in this formula?

[lctrues]

=SUBTOTAL(9,K631:K698)

 

[nbrcrunch]

use your Excel application help system. It will tell you what that is for.

Lookup the keyword: subtotal

You'll find the first argument is the type of subtotalling.

 

[ccoleman]

the first argument for Subtotal is the Function_Num, basically what type of function you're asking it to perform, the possibilies are as follows.

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

 

[schumajm]

Subtotal(9,) is useful when you want to sum a range when a filter is turned on.