SumIf in Visible Cell Range
In Excel 2003 you can summarize hidden rows by using another set of
keys for subtotal (X+100) - see Excel Help for Subtotal function.
SUBTOTAL(9,D2:D7) = Summarize all (visible and invisible) rows
SUBTOTAL(109,D2:D7) = Summarize visible rows only
With the columns however this is not so simple. To know more see the
topic:
"Subtotal function for hidden row"
topola - 13 Paz. 16:04 microsoft.public.excel.worksheet.functions
Topola
|