If I type 1 in a1 and =sum(a1,1) in a2 then copy a2 and paste it in a3 thru
a100 I get 1, 2, 3, 4 and so on all the way down to 100. If I hide several
of the rows, it throws the numbering sequence off. How do I go about
excluding the hidden cells? Couldn't find a IsHidden or similar function to
through in an =if(LogicalTest,True,False) formula/function.

Excel 2003

Much Thanks !!!

Adam L. Kehl