Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidate data | Excel Discussion (Misc queries) | |||
VBA Consolidate Data | Excel Discussion (Misc queries) | |||
consolidate data | Excel Worksheet Functions | |||
Data Consolidate | Excel Discussion (Misc queries) | |||
help to consolidate data | Excel Worksheet Functions |