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<at>tarkon.ee
Arvi Laanemets


"[email protected]" <[email protected]> wrote in
message news:[email protected]...
> Is there a way to combined these two functions in one formula? Summing
only
> the values filtered?