•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Counting - Counts if greater or lesser than a number
I've been trying to find a function or formula that counts the number only if it is greater or lesser than 999. I am currently doing a list on multiple items with values, and I am fairly new to Excel's functions, and I would like to get a quick answer.
I have tried `=COUNTIF(B3:B185,>999)`, but it seems to return an error.
My current version is Excel 2013, and I am using a laptop to do my stuff.
[link] [comments]
Want to read more?
Check out the full article on the original site