In article ,
"R.P.McMurphy" wrote:

ive just tryied it further down the sheet and it seems to work ok...using
this

=(SUMPRODUCT((MOD(COLUMN(G24:FA24),6)=1)*(G24:FA24 <=C24)*G24:FA24)+C24*SUMPROD
UCT((MOD(COLUMN(G24:FA24),6)=1)*(G24:FA24C24)+FJ2 4))*(C24*$E24)/(C24*52)

odd

The reason this works is that you've changed your starting column. The
MOD part...

(MOD(COLUMN(G24:FA24),6)=1)

....means that every 6th cell is evaluated as TRUE starting with G24,
whereas in your previous formula...

(MOD(COLUMN(H6:FB6),6)=1)

....means that every 6th cell is evaluated as TRUE starting with M6 not
H6. To start with H6 you would need to change '=1' to '=2'.

However, you could use the following instead...

(MOD(COLUMN(H6:FB6)-COLUMN(H6),6)=0)

....which would always ensure that every 6th cell is evaluated as TRUE
starting with the first cell in the range, in this case H6. Also, it
would allow you to insert a new column before Column H without affecting
the formula.

Hope this helps!