Ann,

Click onto the fx just above the B column and enter subtotal.

Then click onto "help on this function " in the left hand bottom corner of
the pop-up window.
The next help screen will show you a list of all the variations of subtotals

#2 is count
#9 is sum
etc


--
Greetings from New Zealand
"ann" wrote in message
...
I am not a new user, but I have a question that might be basic about
formulas.
This is the formula that appears when I select Data, Subtotals for my
worksheet.
=SUBTOTAL(9,E2:E1201)

It is the formula in the Grand Total Cell. Can you tell me what the 9,
contained within the parenthesis means? Does that mean it only looks that
the subtotals when calculating the Grand Total?