Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Rows and columns without harming the formulas
Thanks for taking my question. I have a list of names. The list is
seperated by several campaigners and after each campaigners group of names I have a total line. That line has formulas in it that keeps track of all the names for that campaigner. My issue is that if I were to take a row out or add a row to add another name, all the formulas that I have under it get corrupted. How do I stop that from happening and still have the ability to add or delete rows or columns. Thanks again. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Rows and columns without harming the formulas
hi
first, Post the formula you are usning now. second, what is a campaigner? subgroiup???? regards FSt "Stimey83" wrote: Thanks for taking my question. I have a list of names. The list is seperated by several campaigners and after each campaigners group of names I have a total line. That line has formulas in it that keeps track of all the names for that campaigner. My issue is that if I were to take a row out or add a row to add another name, all the formulas that I have under it get corrupted. How do I stop that from happening and still have the ability to add or delete rows or columns. Thanks again. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Rows and columns without harming the formulas
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 other from there on down. "FSt1" wrote: hi first, Post the formula you are usning now. second, what is a campaigner? subgroiup???? regards FSt "Stimey83" wrote: Thanks for taking my question. I have a list of names. The list is seperated by several campaigners and after each campaigners group of names I have a total line. That line has formulas in it that keeps track of all the names for that campaigner. My issue is that if I were to take a row out or add a row to add another name, all the formulas that I have under it get corrupted. How do I stop that from happening and still have the ability to add or delete rows or columns. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 same formulas | Excel Discussion (Misc queries) | |||
adding new rows and keeping the same formulas | Excel Worksheet Functions |