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