in the table below, I have in column A a reference number and in column B a value that is null or positive:
| Reference | Volume |
|---|---|
| 074610 | 100 |
| 074610 | 0 |
| 171546 | 0 |
| 171546 | 200 |
| 751714 | 0 |
| 751714 | 50 |
| 751714 | 0 |
| 789723 | 25 |
Outside of the table, I would like to sum column B only on the values that matches the first row with a different reference. In my example, it would mean that I only add
- the first row for reference 074610,
- the first row for reference 171546,
- the first row for reference 751747,
- etc.
The formula should give a result: 100 + 0 + 0 + 25 = 125 but all the formulas I tried give the total of column without taking into account the first row for each reference number.
Does anyone has an idea of fomula that could work?
Thank you !
Aucun commentaire:
Enregistrer un commentaire