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