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?
|