Use only Month and Year from date as criteria in countifs?
<p>I have an excel countifs formula with multiple criteria:</p>

<pre><code>=COUNTIFS('Opp Data'!$E:$E,Home!$B11,'Opp Data'!$B:$B,Home!$D11)
</code></pre>

<p>My dates appear in column B on my Sheet OPP Data like so:</p>

<pre><code>28/03/2016
21/04/2016
</code></pre>

<p>My lookup value in D11, D12 etc, will appear like so:</p>

<pre><code>March - 2016
April - 2016
</code></pre>

<p>The dates will always be formatted like this.</p>

<p>Is there a way i can amend my countifs formula so that it recognises the month and the year as shown above from the dates in column B on my Opp Data sheet?</p>

<p>I have tried to get started by working on something like the below, but this doesn't work:</p>

<pre><code>=COUNTIFS('Opp Data'!$E:$E,Home!$B11,TEXT('Opp Data'!$B:$B,"mmmm"),Home!$D11)
</code></pre>

<p>Please could someone show me where i am going wrong?</p>

<p>Thanks in advance</p>