•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
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#financial modeling with spreadsheets
#formula generator
#COUNTIF
#COUNTIFS
#Excel
#formulas
#criteria
#function
#2019
#manual count
#tutorials
#online forums
#data range