Add Rows Based on Unique Inoice Number

[zaska]

Dear Team,


INVOICE NO GROSS TOTAL INVOICE VALUE

1001 25 100
1001 25 100
1001 50 100
1002 100 200
1002 100 200

Can anyone help me to Get the Total Invoice Value for Each Invoice Number? Total Invoice Value should be same irrespective of the gross amount for each row.

Thank you

Note: Cross Posted
https://www.excelforum.com/excel-pr...242956-add-rows-based-on-invoice-numbers.html

 

[Yongle]

With invoice no in column A, Gross in column B, this formula in C2 copy down
=SUMIF(A:A,A2,B:B)

For the value to appear only once against each invoice
=IF(COUNTIF($A$2:A2,A2)=1,(SUMIF(A:A,A2,B:B)),"")

 

[zaska]

Thank you so much

 

[Yongle]

thanks for the feedback