In article ,
"r.p.mcmurphy" wrote:

Excel is not accepting it for some reason. any idea where the fault may be?

If you're copying and pasting the formula into your worksheet, make sure
that a line break hasn't been added.

im a bit confused about the bit you added in order to add the value of
BQ4...this bit..

+IF((BQ4<"")*(BQ4C4),C4,BQ4))

why does it refer to C4?

I assumed, incorrectly it appears, that BQ4 would following the same
logic as cells in G4:BJ4. Maybe this what you mean...

=(SUM(IF((G4:BJ4<"")*(MOD(COLUMN(G4:BJ4)-COLUMN(G4),5)=0),IF(G4:BJ4C4,C
4,G4:BJ4)))+BQ4)*0.09615

Is it?