Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

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
0
rckrch
Asked:
rckrch
  • 2
1 Solution
 
SteveCommented:
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))
0
 
rckrchAuthor Commented:
Thanks!!! That worked.  I tried this function before, but it did not work.  Where did the 'N' come from?
0
 
SteveCommented:
N turns a boolean True or False to a 1 or 0
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now