•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#financial modeling with spreadsheets
#formula generator
#Excel
#COUNTIF
#function
#formula
#count
#greater than
#lesser than
#values
#error
#laptop
#list
#items
#version