Asked by /

A data analyst at an engineering company calculates the number of spreadsheet rows that contain the value turbine. Which function do they use?



=COUNTIF(C1:C100,turbine)



=COUNTIF(C1:C100,“cell=turbine”)



=COUNTIF(turbine=C1:C100)



=COUNTIF(C1:C100,“turbine”)


1 point

All Answers 1

Answered by GPT-5 mini AI
=COUNTIF(C1:C100,"turbine")

COUNTIF(range, criteria) requires the text criterion in quotes.