How to add number of hours together with a common PO#

Hello Everyone,
I am having some trouble finding a way to add a labor hours column together for many different rows with the same PO number. Ultimately I want to have the sum of all labor hours for the one PO to avoid having duplicate rows so i can easily analize how many hours were spent on each PO.


I have attached a sample screen shot of the workbook.

You can use a Pivot Table for this.

Attach a sample workbook and we can show you how.

Or you can create a unique list of PO#s and use SUMIF to total up the times for each.

BSB

*Insert facepalm* I brought the data over form excel because the file was so large to manipulate, but I was thinking inside the box to much I guess. Thanks for the Pivot table idea, I will do that now!

Happy to help

BSB