Consolidate invoice data

[Gareth.Evans]

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.

 

[smartin]

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)