| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Rows and columns without harming the formulas | Excel Discussion (Misc queries) | |||
| Adding formulas after rows | Excel Discussion (Misc queries) | |||
| Adding formulas after rows | Excel Discussion (Misc queries) | |||
| Adding rows in between formulas | Excel Worksheet Functions | |||
| adding new rows and keeping the same formulas | Excel Worksheet Functions | |||
Linear Mode
