Sum non-hidden rows

[Guest]

Is there a way to sum non-hidden rows only

I have a spreadsheet with hidden rows. If I create a cell at the end of a column with SUM (A1:A99), it sums all rows in that range whether they are hidden or not. Is there a way to only SUM the non-hidden rows?

 

[Frank Kabel]

Hi
how did you hide the rows?
1. with an filter: If yes use SUBTOTAL:
=SUBTOTAL(9,A1:A99)

2. If you've manuall hidden the rows AND you have Excel 2003 you may
use
=SUBTOTAL(109,A1:A99)

3. If neither of both applies to you you'll need as userdefined
function for this. Post back if you need one!

 

[Guest]

Thank you again, Frank!