Thats working great! thanks! next question, i want to add the value
contained in BQ4 to the array just before the final *0.09615
calculation...can you help?

Thanks!

steve

"Domenic" wrote in message
...
Try...

=SUM(IF(MOD(COLUMN(G4:BJ4)-COLUMN(G4),5)=0,IF((G4:BJ4<"")*(G4:BJ4C4),C4
,G4:BJ4)))*0.09615

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

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

I'm currently working with this array formula...

=SUM(IF(G4:BJ4C4,C4,G4:BJ4))*0.09615

How do i change this so that G4:BJ4 refers to every 5th cell staring with
G4.

Ie G4, L4, Q4, V4 ......etc.

CHeers

steve