=SUMPRODUCT(range_of_Names="A";MONTH(range_of_dates)=MONTH(Date_Cell))
or
=SUM((range_of_Names="A")*(MONTH(range_of_dates)=MONTH(Date_Cell)))
@Mayukh, isn't it?