Sum on Max value in repeated data

Joined
May 7, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016 2019
Hi All

Referring the table below, I wish to sum total invoice value on the line where invoice is ending. Each invoice number has line numbers and sum formula should be applicable only on last line/max line of each invoice. Kindly suggest.

Inv NumberLine NoValueSum by Invoice
3161$500
3162$215
3171$452
3172$125
3173$521
3174$124
3181$150


Thanks
Sats
 

Attachments

  • ExcelGuru11160.xlsx
    14.1 KB · Views: 4
Hi

Assuming your data is in A1:C8, in D2 place the following and copy down.

=IF(A2<>A3,SUMIF($A$2:$A$8,A2,$C$2:$C$8),"")
 
Back
Top