Excel Countifs or SumProduct formulas
<p>I have collision data in column <code>F</code> I have the years from 2004-2015, I have named the range <code>ATT_YEAR</code> and In column <code>G</code> I have the dates and the range is named <code>ATT_DATE</code>. What I am trying to do is to either use <code>COUNTIFS</code> or <code>SUMPRODUCT</code> to determine the number of collisions by month of the year, if I select the year as say 2013, I want to show the number of collisions by month.
I was trying the following the formula:</p>

<pre><code>=COUNTIFS(ATT_YEAR,"2013",ATT_DATE,MONTH=1)
</code></pre>

<p>but not getting very far with one.
Or when I tried using sumproduct formula:</p>

<pre><code>=SUMPRODUCT(--(ATT_YEAR,"2013"),MONTH(ATT_DATE)=1)
</code></pre>

<p>I would be grateful for any assist on either of these.</p>