more than one item group by date and calculate their totals

[jobsinger]

NEWBIE here....

COL 1 COL 2 COL 3
date dos total
11/8/2014 OTP $341.02
11/8/2014 OTS $682.04
12/1/2014 SOP $341.02
12/1/2014 SOS $682.04

Hi -
My data comes out like above. I want to group items in COL 2 together then rename them as well as have their totals in COL 3 be added together.

so then it comes out looking like:

COL 1 COL 2 COL 3
date dos total
11/8/2014 Overtime $1023.06
12/1/2014 Shift Differential $1023.06

would like a formula that can do these changes rather than making manual edits of find and replace. is it even possible?

much appreciated!

[quekbc]

The dates and $ figures can be combined using the SUMIF function. The labels however, OTP / OTS = Overtime and/or SOP / SOS = Shift Differential however, is a little tougher. Are all codes with OT at the start Overtime and SO Shift Differential?

[jobsinger]

Thank you for your response. How do I put the sumif statement together? To answer: Are all codes with OT at the start Overtime and SO Shift Differential? Yes, they all start that way.

Your help is much appreciated!
~jo anne

[quekbc]

I've decided to go down the route of breaking calculations apart.

Under the Combined header, I've combined the dates and the first 2 characters dos together.
I then generate an unique list under the header Unique list.
Using this unique list, I re-generated convert it back to dates and Type (Overtime or Shift Differential)
Apply a SUMIF that I mentioned above to calculate the new totals.

I've added more data to show all possible scenarios (i.e. same date different dos). See attached if it does what you need.

[jobsinger]

thank you thank you - I can work with this!