insert a new cell into an existing formula

[Debbie]

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?

[Bob Phillips]

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" <Debbie@discussions.microsoft.com> wrote in message
news:DE30DEA6-840E-48FB-B372-C9EC015E9258@microsoft.com...
> 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]

Mine is like this:

=SUM(F11+F18+F25+F32+F39+F46+F53+F60+F67+F74+F81+F88+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" <Debbie@discussions.microsoft.com> wrote in message
> news:DE30DEA6-840E-48FB-B372-C9EC015E9258@microsoft.com...
> > 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?
>
>
>

[Bob Phillips]

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" <Debbie@discussions.microsoft.com> wrote in message
news:EE55481F-9EF6-4B37-8009-9D29BFC19C11@microsoft.com...
> Mine is like this:
>
>
=SUM(F11+F18+F25+F32+F39+F46+F53+F60+F67+F74+F81+F88+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" <Debbie@discussions.microsoft.com> wrote in message
> > news:DE30DEA6-840E-48FB-B372-C9EC015E9258@microsoft.com...
> > > 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?
> >
> >
> >