Count cells with specific value in odd columns
|
Range Reference:
|
|
Specific Value:
cell reference where the specific value is captured |
|
Formula:
|
=SUMPRODUCT(--(MOD(COLUMN(C8:I8),2)=1),--(C8:I8=C5))
=SUMPRODUCT(--(MOD(COLUMN(C8:I8),2)=1),--(C8:I8=C5))