I need to evaluate the value in every other column of a row and determine if
it equates to 1,2,3,4,5,6,7,8,9,10 or 11. Each row has a player followed by
each event entered. If the player placed 1 through 11th place, these values
are in the row under each event in every other column (ie, B11:BW11). The
values 1,2,3,4,5,6,7,8,9,10,11 exist in a contiguous array in row 9, in the
range BX:CH. I am trying the following formula, but it doesn't evaluate
correctly:
=SUMPRODUCT(--(MOD(COLUMN($B13:$BW13)-COLUMN($B13)+0,2)=CG$9),(ISNUMBER($B13:$BW13)),--($B13:$BW13=0))

Looks like I need some help.