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)
|