Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum if
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 |
#2
|
|||
|
|||
=sumproduct(--(a1:A100="Employee x"),--(month(b1:b100)=4),c1:c100)
where column a= employee name column b = dates (in the above example april) column c = check amounts "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|