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!
================================================== ===

"Glenn L." <Glenn wrote in message
...
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.

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

--
Gary''s Student - gsnu200794


"Glenn L." wrote:

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

"Glenn L." <Glenn wrote in message
...
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.

=SUMPRODUCT(--(C173:E187=200))-SUMPRODUCT(--(C173:E187224))

Hope this helps.
--
John C


"Glenn L." wrote:

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.

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

"Glenn L." <Glenn wrote in message
...
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.

Something different.

Assuming the numbers are integers.

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

--
Biff
Microsoft Excel MVP


"Glenn L." <Glenn wrote in message
...
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.