=SUBTOTAL(1,A2:A4)
Let us say that the value in A2 = 4, A3 = 4, and A4 = 4. Also, the number 1 with a comma before the cell range means use the Average function to calculate the Subtotal. The answer displayed will be 4. As 4 is the average of cell range A2 to A4 as stated above.
The subtotal function can hold up to 255 ranges or numbers.
Let us say that the value in A2 = 4, A3 = 4, and A4 = 4. Also, the number 1 with a comma before the cell range means use the Average function to calculate the Subtotal. The answer displayed will be 4. As 4 is the average of cell range A2 to A4 as stated above.
The subtotal function can hold up to 255 ranges or numbers.
0 comments:
Post a Comment