Do you have Excel 2003 or later? Just look up SUBTOTAL in help (comes up as
SUBTOTAL worksheet function)


--


Regards,


Peo Sjoblom



"Carla" wrote in message
...
Can you tell me exactly where in help this list would be? I can't seem to
find it.

"Peo Sjoblom" wrote:

COUNTA and SUM, but these will not only sum or count visible cells from
filtering they will do it for hidden cells as well. These were introduced
in
Excel 2003 and they just added 100 to the previous subtotal. It's in help
as
well

--


Regards,


Peo Sjoblom


"Carla" wrote in message
...
OK, in my subtotal formula what would 103 and 109 stand for?
=SUBTOTAL(103,A1:A6148
=SUBTOTAL(109,A1:A6148

"Peo Sjoblom" wrote:

It is all explained in the help file for the SUBTOTAL function,
9 stands for SUM, 2 for COUNT and so on


--
Regards,

Peo Sjoblom



"Pat" .(donotspam) wrote in message
...
Hi! ;)

When subtotals have been created in an excel file - when viewing the
formula
in the address bar what does the "9" stand for: =SUBTOTAL(9,H2:H23)
--
Thanks, Pat