The Range should be obvious, so I assume your question deals with the "9".
That first argument is a function number. There are 11 different function
numbers that can be specified there (actually, 22, 11 that include hidden
values and 11 that exclude them). The function number "9" makes the SUBTOTAL
the cells in the Range whereas the other function numbers do other things.
You should check out the Help files for SUBTOTAL to see everything it can
do.

Rick


"Sherry" wrote in message
...
Hi Peo,

What goes in the brackets?

"Peo Sjoblom" wrote:

There is a subtotal formula function as well

=SUBTOTAL(9,Range)


--
Regards,

Peo Sjoblom



"Sherry" wrote in message
...
Hello,
I have a worksheet with just under 700 lines. This worksheet consists
of
employees, their department and their payroll life insurance deductions
for a
specific pay date. I have grouped them by department and subtotaled
the
deductions. Is there a formula that tells excel I want a grand total
that
only adds the subtotals (because all values are in one column...I
suppose
I
could sum and divide by 2?) Actually that works!

Well, I'll leave the post here in case anyone else is trying to get a
solution!

Thanks for giving me a forum to talk out my problem!

Sherry