Bang on mate! Thanks for everyones help!

steve


"RagDyeR" wrote in message
...
Since you changed your starting column from G to H (Column7 to Column8),
Your Mod formula should have a remainder of 3 instead of 2 (7-5=2, 8-5=3)

Revise your formula to this, and see if it works:

=(SUMPRODUCT((MOD(COLUMN(H4:BK4),5)=3)*(H4:BK4<=(( D4*52)/12))*H4:BK4)+((D4*5
2)/12)*SUMPRODUCT((MOD(COLUMN(H4:BK4),5)=3)*(H4:BK4( (D4*52)/12)))+BR4)*(D4*
$E4)/(D4*52)

If you still have a problem after this change, I would suspect your logic,
in the way you constructed those final two ending calculations, because
the
formula is now syntactically correct.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"r.p.mcmurphy" wrote in message
...
Oops, ignore the different end bit...just see it as 0.09615
ie

=(SUMPRODUCT((MOD(COLUMN(G4:BJ4),5)=2)*(G4:BJ4<=(( C4*52)/12))*G4:BJ4)+((C4*5
2)/12)*SUMPRODUCT((MOD(COLUMN(G4:BJ4),5)=2)*(G4:BJ4( (C4*52)/12)))+BQ4)*0.09
615

works

=(SUMPRODUCT((MOD(COLUMN(H4:BK4),5)=2)*(H4:BK4<=(( D4*52)/12))*H4:BK4)+((D4*5
2)/12)*SUMPRODUCT((MOD(COLUMN(H4:BK4),5)=2)*(H4:BK4( (D4*52)/12)))+BR4)*0.09
615

returns 16.25 lower despite same figures

cheers

steve