Counting data in a range

  • Thread starter Thread starter Glenn L.
  • Start date Start date
G

Glenn L.

I need to count the values that are between and equal to 200 and 224 in the
data range of C173:E187. I've tried eveything I could think of and can't get
it right. Please help.
 
try this array formula

=SUM(IF((C173:E187>=200)*(C173:E187=<224),1,0))

needs to be inserted with CTRL+SHIFT+ENTER
 
A couple of ways:

=Sumproduct((C173:E187>=200)*(C173:E187<=224)

=COUNTIF(C173:E187,">=200")-COUNTIF(C173:E187,">224")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I need to count the values that are between and equal to 200 and 224 in the
data range of C173:E187. I've tried eveything I could think of and can't
get
it right. Please help.
 
Here are 2 ways

=COUNTIF(C173:E187,">=220")-COUNTIF(C173:E187,">224")


or


=SUMPRODUCT((C173:E187>=220)*(C173:E187<=224))



if the range would be bigger the first formula would be more effective



--


Regards,


Peo Sjoblom
 
was one of the things you tried
=COUNTIF(C173:E187,">=200")-COUNTIF(C173:E187,">224") ?
 
Something different.

Assuming the numbers are integers.

=INDEX(FREQUENCY(C173:E187,{199,224}),2)
 
Back
Top