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?

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
...
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?

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
...
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?

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
...
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?