sumifs - Excel Sum If based on month of date range? -

i have sheet list of users , holidays taken so:

katie     1     01/01/2016 dave      2     12/02/2016 dave      2     12/12/2015 katie     1     17/11/20165     liam      1     05/01/2016 marie     1     09/08/2015 marie     5     23/09/2015 

i using following sumif formula on other sheet return total number of holidays taken each person

=sumif(data!a$1:a$1000,a13,data!b$1:b$1000) 

this gives me result so:

katie     2 dave      4 liam      1 marie     6 

however, want turn sumif sumifs returns values month of january so:

katie      1 liam       1 

i know can month of date using =text('cell ref',"mmmm") i'm not sure how combine sumifs statement.

can please show me how can this?

thanks in advance

you need use array formula:

=sum(if((data!a$1:a$1000=a13)*(month(data!c$1:c$1000) = 1),data!b$1:b$1000)) 

since array formula needs confirmed ctrl-shift-enter when leaving edit mode. copied down.