Idiot Excel help being begged.

[Guy Profumo]

OK. So I've got this spreadsheet, and, starting at say, row 26, column "C", I want to add every third value into row 26, column "D".

so Col "D" has got this in it.

=SUMPRODUCT((MOD(ROW($C26:C$6000)-CELL("Row",C26)+0,6)=0)*($C26:C$6000))

I'm also wanting to be able to copy cols. B,C, and E, across to F,G, and H, and then at unspecified times onto the next three when new data needs to be entered.

Sadly, when you do this, G26 contains the following,

=SUMPRODUCT((MOD(ROW($C26:F$6000)-CELL("Row",F26)+0,6)=0)*($C26:F$6000))

Because a number of people will need to use this, is there a way of copying the block of columns of three across to "preserve" the formula, rather than it always using "C26" (or the "start" in what's being copied)?

Cheers!

[ericcantona]

Idiot Excel help being begged.

In the original formula use the cell reference of C26 instead of $C26. This will mean that when you copy it then it will update to F26.

I hope this is what you where after?

[Guy Profumo]

Idiot Excel help being begged.

Yep. Sorted. Many thanks.