Boris

=SUBTOTAL(109,B4:B9) totals visible rows

as opposed to:

=SUBTOTAL(9,B4:B9) totals all rows

Regards

Trevor


"BorisS" wrote in message
...
I believe that before '07, there was some way I could have a sum formula
(or
some derivation of it) that only summed the visible elements of a filtered
list. Any help on what the method is for that?
--
Boris