combining countif with AND function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a bit confused combining these two functions.

What would I use if I wanted to count the cells in a table that are greater
than 1.5 but lower than 2.5?

=countif(B4:H28,AND(">1.5","<2.5")) gives me back an incorrect count, so
I'm doing something wrong.

=)
 
Ooops!

You wanted <2.5, so:

=COUNTIF(B4:H28,">1.5")-COUNTIF(B4:H28,">2.4")

Biff
 
You must log in or register to reply here.

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
Combine Sumif and Countif 3
CountIf previous cell formula 0
countifs Function not giving desired result with date criteria 2
Help Counting Alpha Characters 4
Combining LOOKUP and COUNTIF functions 4
CountIf with And 0
countif where condition should be met 3

Back
Top