general

[Guest]

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

 

[Bob Phillips]

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

--

HTH

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