Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel General Ledger | Excel Discussion (Misc queries) | |||
GETPIVOTDATA General | Excel Worksheet Functions | |||
General Journal | Excel Discussion (Misc queries) | |||
General protection fault in module HPPCL5F4.DLL at 0002:000006c2. | Excel Discussion (Misc queries) | |||
How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) |