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

#### lctrues

##### Board Regular
=SUBTOTAL(9,K631:K698)

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
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.

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

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

Replies
5
Views
108
Replies
3
Views
100
Replies
1
Views
79
Replies
7
Views
82
Replies
3
Views
607

1,206,833
Messages
6,075,130
Members
446,123
Latest member
junkyardforme

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back