Sum cell values matching criteria

kizzie37

Well-known Member
Joined
Oct 23, 2007
Messages
510
Not sure how to go about this, any help would be great. I have a table to capture hours worked, there is a code that denotes if the corresponding hours are standard tome or overtime. example: Mon 7 hours code 2c, Tues 7 hours, code 3c, weds 5 hours code 2c, thurs 2 hours code 4c, fri 2 hours code 2c.

I would like to find all the instances of Code 2c and sum the corresponding hours, same with code 3c & 4c. How would I go about this?
 

Forum statistics

Threads
1,078,148
Messages
5,338,525
Members
399,240
Latest member
mominul2241

Some videos you may like

This Week's Hot Topics

Top