<div>
Try COUNTIFS:<br />
<br />
<b>=COUNTIFS(E36:P36,&quot;&gt;=80&quot;,E<wbr />36:P36,&quot;&lt;=<wbr />90&quot;)</b><br />
<br />
There are many other ways too such as:<br />
<b>=SUMPRODUCT(N(E36:P36&gt;=80)<wbr />,N(E36:P36<wbr />&lt;=90))</b>
</div>


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))

<div>
Thanks!!! That worked. &nbsp;I tried this function before, but it did not work. &nbsp;Where did the 'N' come from?
</div>


Thanks!!! That worked.  I tried this function before, but it did not work.  Where did the 'N' come from?

<div>
<div class="content wysiwyg-content">
I am trying to count the number of value in a range between 2 values. &nbsp;The worksheet formula below returns 0. &nbsp;That is wrong it should return 1. &nbsp;There is one number between 80 and 90 in the range.<br />
<br />
=COUNT(IF(AND(E36:P36&gt;=80,<wbr />E36:P36&lt;=9<wbr />0),&quot;True&quot;,<wbr />&quot;False&quot;))<br />
<br />
Can anyone help?<br />
<br />
Thanks
</div>
</div>


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

Excel Formula for counting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.