Counting data in a range

[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.

 

[Jarek Kujawa]

try this array formula

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

needs to be inserted with CTRL+SHIFT+ENTER

 

[RagDyeR]

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.

 

[Gary''s Student]

=COUNTIF(C173:E187,"< 225")-COUNTIF(C173:E187,"<200")

 

[Peo Sjoblom]

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

 

[John C]

=SUMPRODUCT(--(C173:E187>=200))-SUMPRODUCT(--(C173:E187>224))

Hope this helps.

 

[David Biddulph]

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

 

[T. Valko]

Something different.

Assuming the numbers are integers.

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