I have a kludge work-around for versions prior to Excel 2003 but it requires
the use of a helper column.
A hidden row has a height property of 0 so all you need to do is sum the
rows with a height >0.
Assume the range of interest is A1:A10 but several of those rows are hidden.
Create this named formula:
Insert>Name>Define
Name: Height
Refers to: =GET.CELL(17,INDIRECT("RC",FALSE))
OK
Enter this formula in B1 and copy down to B10:
=Height
It will also be copied to the hidden rows.
Now, to get the sum of only the visible rows in A1:A10
=SUMIF(B1:B10,">0",A1:A10)
Note that hidding or unhidding rows/columns does not trigger a calculation.
If all rows are visible and then you hide some the formula will not show the
correct result until a calculation takes place. You can either wait for some
other action that triggers an automatic calculation or you can hit F9 to
force a calculation.
Like I said, kludge, but it's an option!
Biff