Count if every other 5th cell is equal to 0

Originally Posted by samba_ravi

A3=COUNTIFS(E3:AH3,0,E$1:AH$1,">0")
Try the above, copy and paste towards down

Hah! Nice bit of lateral thinking. Thanks