COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1

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

Guest

I have a range of values. I wish to count the number of values in this row
that are between 5 and 10.1.

How do I do this?
 
John


=COUNTIF(A1:T1,">5")-COUNTIF(A1:T1,">10.09999") for a range.

OR

=COUNTIF(1:1,">5")-COUNTIF(1:1,">10.09999") for entire row.


Gord Dibben Excel MVP

On Tue, 21 Dec 2004 17:01:02 -0800, John Higgins <John
 
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
CountIf previous cell formula 0
Can you use an INDEX array in a COUNTIF formula ? 1
CountIf Function 12
countifs Function not giving desired result with date criteria 2
countif using other cell values for 'range' and 'criteria' 4
Countif, multiple criteria 6
Second largest in array of difference in high-low values in cells 6

Back
Top