<div>
I think it was my mistake - I had another column filtered. &nbsp; But I also wanted to make sure I was seeing the formula correctly.
</div>


I think it was my mistake - I had another column filtered.   But I also wanted to make sure I was seeing the formula correctly.

<div>
<blockquote>
I think it was my mistake - I had another column filtered.
</blockquote>
Be aware that COUNTIFS will count rows even if they have been hidden by a filter. If you want to ignore rows hidden by a filter, you should use either SUBTOTAL or AGGREGATE to do the counting with an array-entered formula. AGGREGATE has a little more power in that you can also ignore rows containing an error value, but it requires Excel 2010 or later. SUBTOTAL has no such restriction. Please post back if you need help building such a formula.
</div>


> I think it was my mistake - I had another column filtered.

Be aware that COUNTIFS will count rows even if they have been hidden by a filter. If you want to ignore rows hidden by a filter, you should use either SUBTOTAL or AGGREGATE to do the counting with an array-entered formula. AGGREGATE has a little more power in that you can also ignore rows containing an error value, but it requires Excel 2010 or later. SUBTOTAL has no such restriction. Please post back if you need help building such a formula.

<div>
<div class="content wysiwyg-content">
I think I understand this formula as I did not input into the sheet. &nbsp;I am manually looking at the results and they do not match what the formula below returns. &nbsp;I am assuming it is looking for the Values from division info in QQ where the values in A match the values in EE on the division tab, but it does not see to work.<br />
<br />
<br />
=COUNTIFS('division info'!E:E,'OCT'!A28,'divis<wbr />ion info'!Q:Q,&quot;&gt;0&quot;)
</div>
</div>


I think I understand this formula as I did not input into the sheet.  I am manually looking at the results and they do not match what the formula below returns.  I am assuming it is looking for the Values from division info in QQ where the values in A match the values in EE on the division tab, but it does not see to work.


=COUNTIFS('division info'!E:E,'OCT'!A28,'division info'!Q:Q,">0")

Countifs formula

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