excel formulas

[racrxr1]

Is there a way to get the formula to recognize new rows
that have been added without having to manually change the
formula to recognize the new rows?

 

[Dave R.]

This may not be the answer you want, but you can always write your formula
to look from the top of the range down to row 9999. If you need to divide or
multiply by the # of entries, you can determine that with a formula that
looks at the range as well.

 

[Frank Kabel]

Hi
one way: using COUNTA and OFFSET (works only if you have no blank rows
in between). e.g.
=SUM(OFFSET($A$1,0,0,COUNTA($A:$A))

 

[Trevor Shuttleworth]

If you assume the cells you want to add are from, say E4 to E9, you could
use this formula in cell E10:

=SUM(E4:OFFSET(E10,-1,))

If you add a row anywhere between row 4 and row 10, the formula will still
work

I guess it depends how complex your formula is ... why not post back with a
specific example ?

Regards

Trevor