On Excel 2003, you can also subtotal "the visible rows if the rows are
hidden by the user".

Alok wrote:
Hi,
I do not think there is a way to total only the visible rows if the rows are
hidden by the user. However, if the hiding takes place as a result of a Data
Filter then you can use the formula

=SUBTOTAL(9,D2:D7)

This will total all the visible rows as long as the hiding of the rows takes
place as a result of the filter.

Alok

"Terri" wrote:


How do you set the range in the SumIf if you only want to refer to visible
cells in the range and not all the cells?

Thanks to all of You!

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.