architectdon
New Member
- Joined
- Jun 26, 2018
- Messages
- 1
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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vendor charging the same item on multiple invoices and I need assistance
Yongle
Well-known Member
- Joined
- Mar 11, 2015
- Messages
- 6,977
- Office Version
- 365
- Platform
- Windows
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
=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
Last edited:
Upvote
0
