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


"tgallagan@aol.com" <tgallaganaolcom@discussions.microsoft.com> wrote in
message news:B0629EAA-FE99-4B3C-B429-A7FEC999F60D@microsoft.com...
>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?