What does the number mean in the subtotal function?
P Peo Sjoblom Sep 3, 2004 #2 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)
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)
H Helen Trim Sep 3, 2004 #4 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
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
D Dave Sep 3, 2004 #5 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 . Click to expand...
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 . Click to expand...
