Countifs by Day in the Month

[fgruhlke]

See attached work book, trying to count how many times an employee comes up on a particular day of the month. I think I am close using countifs and the Day function but still missing something

The work book better explains what I am trying too do!!

Thanks all in advance!

[Ace_XL]

Try

=SUMPRODUCT(($G$3:$G$14=$I$3)*(DAY($F$3:$F$14)=$I$1))

[Fluff13]

How about
=SUMPRODUCT((G3:G14=I3)*(DAY(F3:F14)=I1))

[fgruhlke]

Thanks Ace! this works great!!!