Adding Rows or Columns without harming formulas.

[Stimey83]

Thank you for taking my question!

First, I work for a non-profit. A campaigner is someone that is helping to
solicit donations. We have 40 campaigners and each campaigner is assigned
prospects. So say rows 2-15 are bob's prospects then row 16 is where his
totals are. The formulas then would be the sum of 2-15, say, =sum(E2:E15)
and the total of them is in E16. Then if I try to add another row somewhere
in there, it messes up that formula and all the others from there on down.
Please help!

 

[Jim Cone]

Name the range E215 something like "BobSales."
To sum the range use... = Sum(BobSales)
When a row is inserted or deleted the named range will automatically adjust.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Stimey83"
wrote in message
Thank you for taking my question!

First, I work for a non-profit. A campaigner is someone that is helping to
solicit donations. We have 40 campaigners and each campaigner is assigned
prospects. So say rows 2-15 are bob's prospects then row 16 is where his
totals are. The formulas then would be the sum of 2-15, say, =sum(E2:E15)
and the total of them is in E16. Then if I try to add another row somewhere
in there, it messes up that formula and all the others from there on down.
Please help!

 

[Jim Cone]

Typo...

E215 should have been E2:E15
'--
Jim Cone



"Jim Cone"
wrote in message Name the range E215 something like "BobSales."
To sum the range use... = Sum(BobSales)
When a row is inserted or deleted the named range will automatically adjust.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Stimey83"
wrote in message
Thank you for taking my question!

First, I work for a non-profit. A campaigner is someone that is helping to
solicit donations. We have 40 campaigners and each campaigner is assigned
prospects. So say rows 2-15 are bob's prospects then row 16 is where his
totals are. The formulas then would be the sum of 2-15, say, =sum(E2:E15)
and the total of them is in E16. Then if I try to add another row somewhere
in there, it messes up that formula and all the others from there on down.
Please help!