Try...

=SUMPRODUCT(--(MOD(COLUMN(D31:N31)-COLUMN(D31),2)=0),--(D31:N31+09),--(D
31:N31+0<28),E31:O31)

Hope this helps!

In article ,
"Soccer_Ref" wrote:

I have 12 columns of data. I need to create if commands that if the data on
column 1 is between a certain range to transfer the amount, if not, try the
next column, for six columns.
sample data
D E F G H I J K L
M N O
88 2.4928 10 0.1320 34 2.1868 70 3.0765 06 0.7635
98 1.1165 20 0.0290 62 0.3520 44 0.7791 80 1.5846 06 0.1670
working formula but only looks at half the range

=+IF(D319,IF(D31<28,E31,IF(F319,IF(F31<28,G31,IF (H319,IF(H31<28,I31,0))))))

I have gotten this far and it works, but the IF Function only allows 100
caracters and I would fall short. I need some other alternative to get the
same job done.

Thanks