general

R

rb

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
 
B

Bob Phillips

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

--

HTH

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