try this idea. Modify to suit your column instead of row
=SUM(IF(G1:G31C4,G1:H31)*(MOD(ROW(G1:H31)-ROW(G1),5)=1))

--
Don Guillett
SalesAid Software

"R.P.McMurphy" wrote in message
...
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