Adding rows and updating funtions

[Matt Dwyer]

I have a spreadsheet that displays individual
performance records. On the top of the spreadsheet are
the performance totals (calculated as =SUM
(F60,F93,F126,F159,F192,F225)), based on the individual
performance records which are listed below the totals.
It has become tedious to add new records. Currently, I
copy and paste an existing indvidual record. Then I must
manually update the totals functions to include new cells.
If possible, I need a macro that will copy a selection
of rows every 33 rows. As well, I need a macro to update
the totals function to include the new cell (i.e. add
cell F258 to the above formula).

 

[Frank Kabel]

Hi
use the following formula instead:
=SUMPRODUCT(--(MOD(ROW(F1:F1000)-60,33)=0),F1:F1000)

 

[Matt Dwyer]

Thanks for the quick response.

I do not think =SUMPRODUCT(--(MOD(ROW(F1:F1000)-60,33)
=0),F1:F1000) works for what I need. It included the new
cell when I copied and pasted an individual record.
However, when I tried to change the value one cell, the
total did not change.
Basically, a formula that will add together the values
within every 33rd cell in a column would make life
happy.

 

[Frank Kabel]

Hi
yes this is what this formula dows. Adding every 33rd cell starting
with cell F60. If the total does not change check under 'Tools -
Options - Calculate' that 'Automatic calculation' is enabled.

also change the formula to:
=SUMPRODUCT(--(MOD(ROW(F60:F1000)-60,33)=0),F1:F1000)
if you start in row 60

 

[Matt Dwyer]

Thanks!
I changed the formula slightly ot start from row 39
(where the individual data begins and it works like a
charm).