Is there a way to combined these two functions in one formula? Summing only the values filtered?
T tgallagan Apr 22, 2005 #1 Is there a way to combined these two functions in one formula? Summing only the values filtered?
A Arvi Laanemets Apr 22, 2005 #2 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.
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.
