•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
Our take
Counting values based on specific criteria can streamline your data analysis in Excel. If you're looking to count items greater or lesser than 999, the `COUNTIF` function is indeed the right choice, but it requires proper syntax. For example, to count values greater than 999, you should use `=COUNTIF(B3:B185, ">999")`. Remember to include the quotation marks around the condition. This approach will help you efficiently analyze your list of items, enhancing your productivity with Excel.
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]
Read on the original site
Open the publisher's page for the full experience
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