SUMIFS Help

[Gambit79]

Hi All

I am having a lot of trouble trying to figure out a formula

I have a spreadsheet that is an extract from another system, it has peoples names, dates and hours worked.

In another spreadsheet I need to figure out how many days that they have worked by month.
i wrote a formula to calcualte the days but can't figure out how to automatically find them and add them based on a couple of criteria.

I've attached my spreadsheet

what I want to do is in the actuals sheet, under the month, I want to look for and add all the days that the person in column A has worked for that specific month, i.e. how many days has Adam worked for December.

Appreciate any help you may be able to offer.
Import Sheet

EMP NAME	Work Date	EFFORTS HRS	Days
Adam	01-Dec-13	7.5	1
Adam	02-Dec-13	7.5	1
Adam	01-Jan-14	7.5	1
Adam	02-Jan-14	7.5	1
Adam	01-Feb-14	7.5	1
Adam	02-Feb-14	7.5	1

<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>

Actuals Sheet

		Dec-13	Jan-14	Feb-14
Adam
Mike
James
John
Mathew
Jim
Luke
Dianne
Nick
Bob

<tbody>
</tbody><colgroup><col><col span="4"></colgroup>

 

[vlady]

maybe like this

=SUMPRODUCT((MONTH(Import!$B1:$B100)=MONTH(Actual!A1))*(YEAR(Import!$B1:$B100)=YEAR(Actual!A1))*(Import!$A1:$A100=Actual!$F10)*Import!$D$1:$D$100)
if the above works you can delete the colored blue below


Actual!A1 contains the date December 2013 B1=january 2014 ....C1,d1
F10 contains the first name down