Need help to get Totals by month with criteria

[devilchild99]

Hey there,

What I am trying to do is get total for month by subject.
On sheet one is the Data, On sheet 2 is name of person.
Trying to get how many testing 1 and testing 2 by month and who it was.
So C14 should show how many people in January were Testing 1 and C15 should show how many in January was Testing 2.
It needs to check the name C1 to Data, if yes , check date if date is in January, check to see if testing 1 or testing 2 than insert # of people.

Hope this helped explain what I am trying to accomplish, sorry if its hard to understand. I attached the document I am testing with.
sample.xlsx

Thanks for your time and help.

[FDibbins]

How is this thread significantly different from your last thread...
http://www.excelforum.com/excel-form...e-problem.html

[devilchild99]

Well on this one I am trying to key off the word january to the # 1/1/2013 in a date. February to the date 2/1/2013 and so on. didnt know excel will see January and recognize it in the date format.

[Ace_XL]

In C14

=SUMPRODUCT((Data!$A$2:$A$6=$C$1)*(TEXT(Data!$C$2:$C$6,"mmmm")=$C$13)*(Data!$F$2:$F$6=D14))

Copy down