Sumifs error while using month function.

Hi Friends,

I have a spreadsheet with three columns in it....Column A: Date, Column B: Sales Rep and Column C: Sale.
I am trying to use sumifs to find out the total sale of a particular sales rep (first criteria) on monthly basis. Column A: Date is filled with dates with custom date format dd/mm/yyyy. I also have a named range MothsList on my worksheet having months name (January,February......,December) with corresponding month number (1,2......12). I am using the below formula and getting error........

=SUMIFS(C2:C12,B2:B12,E2,MONTH(A2:A12),VLOOKUP(F2,MothsList,2))

here E2 is the criteria for sales rep and F2 is the criteria for month name and here is the formula evaluation with F9


=SUMIFS({213254;213545;21546;45621;85462;21654;745613;2168462;124657;142546;254652},{"A";"B";"A";"C";"A";"B";"A";"C";"A";"B";"C"},"A",{1;1;1;1;1;1;1;2;2;2;2},VLOOKUP("January",{"January",1;"February",2;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2))

Everything seem to be correct but I am unable to enter the formula. Any suggestions ?

Please help.

Thanks in advance.

try this
=SUMPRODUCT((Sales_Reps=E2)*(MONTH(Dates)=VLOOKUP(F2,MothsList,2,FALSE)),C2:C12)

Thanks acerrhod ! for your reply.
sumproduct() works well with the given scenario but I only wanted to know that what went wrong with the formula using sumifs(). Is there any correction I need to make in the sumifs() formula to get the desired output ?
In excel you can achieve the same task by using multiple available functions, but here the challenge is to use sumifs() with the given scenario.
Its the matter of curiosity that why my formula is not working ?

Thanks.

Try

=SUMIFS(C2:C12,B2:B12,E2,Dates,">=" &DATE(2013,MONTH($F$2&0),1),Dates,"<=" &EOMONTH(DATE(2013,MONTH($F$2&0),1),0))