• July 17, 2017
###### Announcement: New site design for Microsoft Community

In July, Microsoft will roll out the first of ongoing site improvements aimed to modernize Microsoft Community and help customers get the most out of their community experience.

• During the roll out period, you may see the old or new site design depending on your location

• We expect the roll out to finish by 31 July

Note: Past private message conversations will not move to the new site design. Please save any private messages you would like to keep.

Thank you for being part of Microsoft Community!

Question
Applies to
96 views

# Adding Total per invoice- some have multiple lines

I am looking for a formula to give the total amount per invoice.

Some invoices have more than one line.

Column A invoice #

Column B Invoice amount

Column C Total per invoice

 Invoice # Billing Total 602 50.00 50.00 159 75.00 75.00 847 100.00 847 100.00 847 100.00 300.00 510 80.00 80.00 987 100.00 100.00

### Abuse history

I am looking for a formula to give the total amount per invoice ... Some invoices have more than one line.

A SUMIF() should suffice.

The formula in C2 is,
=IF(A2<>A3,SUMIF(A:A,A2,B:B),0)
... which is filled down as necessary. I used Accounting style number formatting to represent the zeroes as hyphens.
Be the first person to mark this helpful

### Abuse history

In D2 have given an array formula:

=IF(A2=A3,"",SUM(IF(\$A\$2:\$A\$8=A2,\$B\$2:\$B\$8,0)))

Pls press Ctrl+Shift+Enter after inserting in D2.

 Column--> A B C D Row--> 1 Invoice # Billing Total Formula 2 602 50 50 50 3 159 75 75 75 4 847 100 5 847 100 6 847 100 300 300 7 510 80 80 80 8 987 100 100 100

To Love, To Learn, To Live
Be the first person to mark this helpful