• 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.

     Learn more about the upcoming site improvements in this thread.

    Thank you for being part of Microsoft Community!

 
Question
96 views

Adding Total per invoice- some have multiple lines

Philip Bendall asked on

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

1 person had this question

Abuse history


The answered status icon Answer
Jeeped replied on

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


The answered status icon Answer
MyNameIsJaved replied on

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

Abuse history


progress