=SUBTOTAL(9,D61:D62) What does the 9 mean in this equation?
C CLR Oct 16, 2006 #2 The 9 invokes the SUM function. Here's the list from HELP. Function_Num Function 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP hth Vaya con Dios, Chuck, CABGx3
The 9 invokes the SUM function. Here's the list from HELP. Function_Num Function 1 AVERAGE 2 COUNT 3 COUNTA 4 MAX 5 MIN 6 PRODUCT 7 STDEV 8 STDEVP 9 SUM 10 VAR 11 VARP hth Vaya con Dios, Chuck, CABGx3