Hey

I'm looking for a way to sum rows but ignore the adjacent rows which are hidden. excel is adding the stuff in the unhide rows (which is what i want) but also adding the hidden row numbers too (which i don't want).

cheers for the help.