Question
83 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
Asadulla Javed 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