Getting error message NAME?

steve

"RagDyer" wrote in message
...
Would you perhaps be interested in a *non-array* formula?

Try this:

=(SUMPRODUCT((MOD(COLUMN(G4:BJ4),5)=2)*(G4:BJ4<=C4 )*G4:BJ4)+C4*SUMPRODUCT((M
OD(COLUMN(G4:BJ4),5)=2)*(G4:BJ4C4))+BQ4)*0.09615

--
HTH,

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


"r.p.mcmurphy" wrote in message
...
That's it! Brilliant!

however there seems to be a problem with the original part now. where i
wanted each 5th cell to be read, if the value of that cell was higher
than
cell C4 then C4's value would take precedent.

thanks for your help!

steve

"Domenic" wrote in message
...
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?