Subtotal Function

[Dave]

What does the number mean in the subtotal function?

 

[Peo Sjoblom]

It tells you which function subtotal will use, i.e. 9 is SUM, 3 is COUNTA, 2
is COUNT, 1 is AVERAGE
You can look it up under help

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Don Guillett]

have you looked in HELP index for SUBTOTAL?

 

[Helen Trim]

It is the number that specifies which function to use in
calculating subtotals.

Number Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

 

[Dave]

thanks

Dave

-----Original Message-----
It is the number that specifies which function to use in
calculating subtotals.

Number Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

.