Can you combined the SUMIF and SUBTOTAL functions in a formula?
 

I want set up a summary sheet for twenty plus criteria that will sum only the
filtered columns. Is there a way to combined these two functions in one
formula?

=SUBTOTAL(9,Range)

will sum visible rows

if you need a criteria

http://tinyurl.com/2wx8u

--
Regards,

Peo Sjoblom


" wrote in
message ...
I want set up a summary sheet for twenty plus criteria that will sum only
the
filtered columns. Is there a way to combined these two functions in one
formula?