CountIf between two numbers

Joey135

I would like to count how many people scored between 99.5 and 99.9. Here is my formual.

=COUNTIFS(Janury2:January12; >=99.5; January2:January13; <=99.9)

bisaacs

Hey @Joey135,

It looks like you spelled January wrong in the first half of the COUNTIF statement, and you put semicolons instead of commas in every part of the formula. Smartsheet formulas use commas instead of semi-colons to separate parts of a function:

=COUNTIFS(January2:January12, >=99.5, January2:January13, <=99.9)

Hope this helps!

bisaacs

Hey @Joey135,

It looks like you spelled January wrong in the first half of the COUNTIF statement, and you put semicolons instead of commas in every part of the formula. Smartsheet formulas use commas instead of semi-colons to separate parts of a function:

=COUNTIFS(January2:January12, >=99.5, January2:January13, <=99.9)

Hope this helps!