5 Mar 2024 ... How Do You Use COUNTIF with Greater Than or Less Than? · If your criteria is just a number, no quotes are needed (e.g., =COUNTIF(B5:B17, 60) ).