Hi Aladin

Just a small caveat, when rows are hidden by the user, then to have them
ignored by Subtotal(), you have to add 100 to the normal number for the
function required.
=SUBTOTAL(109,D2:D7)

=SUBTOTAL(9,D7:D27) will behave the same as in earlier versions of Excel
i.e. it will not ignore user hidden rows.

Regards

Roger Govier



Aladin Akyurek wrote:

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!