Vendor charging the same item on multiple invoices and I need assistance

[architectdon]

I have a vendor that is billing invoices, and overtime has billed hours multiple times. How can I show the item and hours for each invoice to show a running total?

 

[Yongle]

With Item in column A and hours in column B, put this in C2 copy down
=SUMIF(A$2:A$1000,A2,B$2:B$1000)

To make the total only appear against the first for each item, use this instead
=IF(COUNTIF(A$2:A2,A2)=1,SUMIF(A$2:A$1000,A2,B$2:B$1000),"")


Something to take account of - you have not told us how the "hours" are recorded
- above code assumes that hours are in decimal form 1.25 (ie 1 hour 15 miniutes)
- if that is not the case then the formula needs adjusting to get the calculations correct