sorry, see 2nd error in item I was describing, if using this as an example:

=SUMPRODUCT(--(MOD(COLUMN($FE9:$FX9),2)=MOD(COLUMN($FX9),2)),$FE 9:$AJ9,$FF9:$FW9)

should say: (AJ should be FX, ($FX9),2 should be ($FE9,2

=SUMPRODUCT(--(MOD(COLUMN($FE9:$FX9),2)=MOD(COLUMN($FE9),2)),$FE 9:$FX9,$FF9:$FW9)


"Mike H" wrote:

Hi,

I think you need to post some sample data and a description of what your
trying to do.

Mike

"Nastech" wrote:

hi, not sure if need use of MOD, or INDEX / OFFSET..
I have 10 double columns of data, but only need the 1st col to figure into a
portion of a formula. (specifically, FE - FX), have a fixed cell where
designating number of columns to offset: $C$2

not sure how to apply, but think MOD is needed?
thanks