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?