<div>
thank you for the quick answer
</div>


<div>
Assuming the range is 1,2,3 then try<br />
=COUNTIFS(H1:H9999,&quot;= 17&quot;,P1:P9999,&quot;&lt;4&quot;)-COUNTIF<wbr />S(H1:A9999<wbr />,&quot;= 17&quot;,P1:P9999,&quot;=2&quot;)
</div>


Assuming the range is 1,2,3 then try
=COUNTIFS(H1:H9999,"= 17",P1:P9999,"<4")-COUNTIFS(H1:A9999,"= 17",P1:P9999,"=2")

<div>
<div class="content wysiwyg-content">
I need to count row P in my excel spreedsheet if row H &gt;&nbsp;17 and row P = 1 or 3. &nbsp;<br />
<br />
How can I write the query to do this in and excel field.<br />
<br />
thanks
</div>
</div>


I need to count row P in my excel spreedsheet if row H > 17 and row P = 1 or 3.  

How can I write the query to do this in and excel field.

thanks

count row in excel if = to 2 conditions

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