Look up help on the SUBTOTAL function. It can be used to include/exclude
filtered values in a variety of calculations (sum, count, average, etc...).
It works great in Excel 2003, but I believe its uses may have been more
limited in earlier versions.

HTH,
Elkar


"BorisS" wrote:

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