SyntaxFix
Write A Post
Hire A Developer
Questions
Tags
I need a formula to count the number of cells in a range that are between 10 and 10.000:
I have:
=COUNTIF(B2:B292,>10 AND <10.000)
But how do I put the comparison operators in without getting a formula error?
This question is related to excel range formula
excel
range
formula
Example-
For cells containing the values between 21-31, the formula is:
=COUNTIF(M$7:M$83,">21")-COUNTIF(M$7:M$83,">31")
=COUNTIFS(H5:H21000,">=100", H5:H21000,"<999")
Source: Stackoverflow.com