•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
COUNTIFS not working correctly and I'm just confused on what to do.
I am trying to learn the COUNTIF formula.
=COUNTIFS($S$13:$S$61, ">=95", $S$13:$S$61, "<=97")
The function counted that there are 2 that fills this criteria; however, I counted it manually and there should be 3 instead. The same goes for other formulas I inputted. I watched Youtube tutorials and read online forums but I still don't get what is wrong with the function. I use Excel 2019. What can I do to improve or solve it?
[link] [comments]
Want to read more?
Check out the full article on the original site