CountIf function

  • Thread starter Thread starter Bridget Stacy
  • Start date Start date
B

Bridget Stacy

I want to find all the values in a table that are between
500,000 and 1,000,000.

I used the countif function for the range with the
criteria (>=500,000 and <1,000,000) but it keeps returning
a count of 0 and I know there are numbers in the range
that fall between 500,000 and 1,000,000.

What am I doing wrong?
 
Bridget, here is one way
=COUNTIF(A1:A20,">49999")-COUNTIF(A1:A20,">1000000")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Back
Top