CountIf function

[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?

 

[Paul B]

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 **

 

[Don Guillett]

use sumproduct
=sumproduct((rngA>=500000)*(rngA<1000000))