The following formula works well to add the numbers in column Y for rows that meet the Month criteria determined in cell H57.

So a 1 in H57, adds all the numbers in Y for January.

=SUMPRODUCT(1*(MONTH(D2:D10000)=H57),Y2:Y100

I would like to add another criteria to this to check column A for an employee number. So I could find the total of Bob's Y,s for January
And then a similar formula to find the average of Bob's Y's for January

I tried adding various concoctions using Sumifs but cant seem to nail it down..

Any Ideas?