COUNTIF >50<60

J

jngil

Please ...
In a list of cells with a mixed range of values, I use the "COUNTIF" functin to
count values ">50", for example, but I'de like to have a count of values from
50 to 60. Does anyone kows how to use COUNTIF to count a range of values
?
Thanks !
 
B

Bob Greenblatt

Please ...
In a list of cells with a mixed range of values, I use the "COUNTIF" functin
to
count values ">50", for example, but I'de like to have a count of values from
50 to 60. Does anyone kows how to use COUNTIF to count a range of values
?
Thanks !
Click to expand...


Try an array formula, like: =sum((range>50)*(range(<60)) After entering
this in the formula bar, press Apple-Shift-enter.
 
J

JE McGimpsey

jngil said:
Please ...
In a list of cells with a mixed range of values, I use the "COUNTIF" functin
to
count values ">50", for example, but I'de like to have a count of values from
50 to 60. Does anyone kows how to use COUNTIF to count a range of values
?
Click to expand...

One way:

=COUNTIF(A1:A100,">50") - COUNTIF(A1:A100,">60")

another:

=SUMPRODUCT(--(A1:A100>50),--(A1:A100<=60))
 

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

Using <= in countifs statement 1
Auto populate value from one task to another in MS PROJECT 0
Countif >50<60 5
How to display zero value in blank fields of Cross Tab query 0
If and Countif 2
If with countif or counta 3
Section and Page numbering 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top