Combining SUMIF and SUBTOTAL functions
 

Is there a way to combined these two functions in one formula? Summing only
the values filtered?

Hi

=SUBTOTAL(9,YourRange)
sums filtered values

=SUBTOTAL(1,YourRange)
calculates an average of filtered values

=SUBTOTAL(2,YourRange)
counts filtered numeric values (an equivalent of COUNT)

=SUBTOTAL(3,YourRange)
counts all filtered values (an equivalent of COUNTA)
etc.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


" wrote in
message ...
Is there a way to combined these two functions in one formula? Summing
only
the values filtered?