# Excel Formula for counting

I am trying to count the number of value in a range between 2 values.  The worksheet formula below returns 0.  That is wrong it should return 1.  There is one number between 80 and 90 in the range.

=COUNT(IF(AND(E36:P36>=80,E36:P36<=90),"True","False"))

Can anyone help?

Thanks
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Cost AccountantCommented:
Try COUNTIFS:

=COUNTIFS(E36:P36,">=80",E36:P36,"<=90")

There are many other ways too such as:
=SUMPRODUCT(N(E36:P36>=80),N(E36:P36<=90))
Author Commented:
Thanks!!! That worked.  I tried this function before, but it did not work.  Where did the 'N' come from?
Cost AccountantCommented:
N turns a boolean True or False to a 1 or 0

Experts Exchange Solution brought to you by