Consolidate invoice data
Gareth.Evans wrote:
Hi all, I have a sheet which contains detials of invoices. I wish to consolidate the infomation of the invoices and sum the amounts per invoice. Example: Invoice Number | Inoive amount 2 100 2 50 2 10 3 20 3 60 Outcome after fundtion/macro: Invoice Number | Inoive amount 2 160 3 80 Hope that makes sense, and hope someone out their can help. Mnay Thanks. Use SUMIF. Suppose the detail is in A1:B6 of a worksheet called Detail and you want the summary in A1:B3 of a another worksheet (same workbook) called Summary. Assuming you already filled in the invoice numbers in Summary, the formula in Summary B2 is =SUMIF(Detail!A:A,A2,Detail!B:B) |
All times are GMT +1. The time now is 07:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com