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.