sathishmadhav@gmail.com
New member
- 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.
Thanks
Sats
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 Number | Line No | Value | Sum by Invoice |
316 | 1 | $500 | |
316 | 2 | $215 | |
317 | 1 | $452 | |
317 | 2 | $125 | |
317 | 3 | $521 | |
317 | 4 | $124 | |
318 | 1 | $150 | |
Thanks
Sats