Countif

G

Guest

Excel 2003. Using countif for a range R3:X23. Want to find the number of
numbers greater than or equal to 10,000 but less than 20,000.
Thanks.
Bob
 
G

Guest

One way is to use two COUNTIFs, i.e.

=COUNTIF(R3:X23,">=10000")-COUNTIF(R3:X23,">=20000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
COUNTIF....how to use >=0 but <9 as CRITERIA 3
Excel Formula 2
Excel - count if a number falls within an array in a column & add 3
Excel to COUNTIF if number greater than one but less than another 2
Countif, plus ? 8
COUNTIF 8
Countif problem 2

Top