hi

=SUM(IF(SUM(G3,L3,P3,U3,Z3)C3,C3,SUM(G3,L3,P3,U3, Z3))*0.09615)

you will have to add more cells but i tested this and it worked on my pc.

Regards
FSt1

"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