If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
insert a new cell into an existing formula
I have a simple formula in excel that adds every 7th row for a total. When I
add rows to this worksheet (in the center), the formula does not update to reflect the new cells. How do I get the SUM formula to update? |
#2
|
|||
|
|||
A formula such
=SUMPRODUCT((A1:A20)*(MOD(ROW(A1:A20),7)=0)) will reflect the changes if a row is inserted within the range. What is yours like? -- HTH RP (remove nothere from the email address if mailing direct) "Debbie" wrote in message news I have a simple formula in excel that adds every 7th row for a total. When I add rows to this worksheet (in the center), the formula does not update to reflect the new cells. How do I get the SUM formula to update? |
#3
|
|||
|
|||
Mine is like this:
=SUM(F11+F18+F25+F32+F39+F46+F53+F60+F67+F74+F81+F 88+F95+F102+F109+F116+F123+F130+F137+F144+F158+F16 5+F172+F179+F186+F193+F200+F207+F214+F221+F228+F23 5+F242+F249+F256+F263+F270+F277+F284) I have inserted new rows 151 through 155. Now I need to have this formula update to include F151, the next down to reflect F152, the next one F153, etc "Bob Phillips" wrote: A formula such =SUMPRODUCT((A1:A20)*(MOD(ROW(A1:A20),7)=0)) will reflect the changes if a row is inserted within the range. What is yours like? -- HTH RP (remove nothere from the email address if mailing direct) "Debbie" wrote in message news I have a simple formula in excel that adds every 7th row for a total. When I add rows to this worksheet (in the center), the formula does not update to reflect the new cells. How do I get the SUM formula to update? |
#4
|
|||
|
|||
Debbie,
Try this instead =SUMPRODUCT(--(F11:F284),--(MOD(ROW(F11:F284),7)=4)) -- HTH RP (remove nothere from the email address if mailing direct) "Debbie" wrote in message ... Mine is like this: =SUM(F11+F18+F25+F32+F39+F46+F53+F60+F67+F74+F81+F 88+F95+F102+F109+F116+F123 +F130+F137+F144+F158+F165+F172+F179+F186+F193+F200 +F207+F214+F221+F228+F235+ F242+F249+F256+F263+F270+F277+F284) I have inserted new rows 151 through 155. Now I need to have this formula update to include F151, the next down to reflect F152, the next one F153, etc "Bob Phillips" wrote: A formula such =SUMPRODUCT((A1:A20)*(MOD(ROW(A1:A20),7)=0)) will reflect the changes if a row is inserted within the range. What is yours like? -- HTH RP (remove nothere from the email address if mailing direct) "Debbie" wrote in message news I have a simple formula in excel that adds every 7th row for a total. When I add rows to this worksheet (in the center), the formula does not update to reflect the new cells. How do I get the SUM formula to update? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
inserting data from a row to a cell, when the row number is specified by a formula in a cell | [email protected] | New Users | 2 | January 6th, 2005 07:18 AM |
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | o0o0o0o | Worksheet Functions | 6 | November 19th, 2004 03:13 PM |
Putting in formula to process cell above | Chuck Roberts | General Discussion | 1 | June 18th, 2004 04:11 PM |
Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |