Adding Rows or Columns without harming formulas.
 

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!

Adding Rows or Columns without harming formulas.
 

Name the range E2:D15 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!

Adding Rows or Columns without harming formulas.
 

Typo...

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



"Jim Cone"
wrote in message Name the range E2:D15 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!