Both (9, ... and (109, ... ignore rows hidden by the filter. The difference
is in the treatment of manually hidden rows.
--
David Biddulph

"Trevor Shuttleworth" wrote in message
...
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