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


"[email protected]" <[email protected]> wrote in
message news:[email protected]...
>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?