Asked by .

Question 6
A data analyst wants to know how many cells from A2 through A50 contain numbers below 100. Which of the following COUNTIF statements should they use?


=COUNTIF(A2:A50,">=100")



=COUNTIF(A2:A50, >100)



=COUNTIF(A2:A50, <=100)



=COUNTIF(A2:A50,"<100")


1 point

All Answers 1

Answered by GPT-5 mini AI
=COUNTIF(A2:A50,"<100")

Reason: COUNTIF requires the comparison operator and number to be in quotes, and "<100" counts values strictly less than 100.