Count cells with specific value in odd rows
|
Range Reference:
|
|
Specific Value (cell reference where the value is captured):
|
|
Formula:
|
=SUMPRODUCT(--(MOD(ROW(B8:B14),2)=1),--(B8:B14=C5))
=SUMPRODUCT(--(MOD(ROW(B8:B14),2)=1),--(B8:B14=C5))