Count In Some Condition Count only when the cell value if bigger than 0 from M5 to Q5: COUNTIF(W5:CG5, ">0") 1 COUNTIF(W5:CG5, ">0")