general
 

My Worksheet has columns with names of employees, check dates and check
amounts, Im looking for a formula to add up all the earnings for a specific
employee for a specific month.
Thank you

=SUMPRODUCT(--(A1:A100="employee"),--(MONTH(B1:B100)=4(,C1:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rb" wrote in message
...
My Worksheet has columns with names of employees, check dates and check
amounts, I'm looking for a formula to add up all the earnings for a
specific
employee for a specific month.
Thank you