I need to be able to assign a value (price) to each type of wine (malaje, malavia, malapipa, etc…) in the columns, so that in the final column (Bottle Sales) will appear the total price of the wine sold.
I’ve tried several formulas, but nothing works. I should also mention that it is a Spanish version of Excel 2016 and uses ; instead of ,,
| Malaje | Malavia | Malapipa | Canibal Chard | Flor | Malvajio | Canibal Tinto | Vermut | Naranja | Espumoso | TotalBottles | Bottle Sales |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 8 | 1 | 11 | ||||||||
| 1 | 2 | 1 | 5 | 1 | 2 | 12 | |||||
| 2 | 2 | 4 | |||||||||
| 1 | 3 | 1 | 1 | 6 | |||||||
| 1 | 1 | 2 | 2 | 1 | 7 | ||||||
| 1 | 2 | 2 | 2 | 7 | |||||||
| 3 | 3 | ||||||||||
| 3 | 4 | 1 | 5 | 13 | |||||||
| 2 | 3 | 5 | |||||||||
| 0 | |||||||||||
| 6 | 8 | 5 | 2 | 21 |
I have tried various formulas that I found here for similar problems, but always get either a pop up saying that I am creating a formula, but If I don’t want a formula add a ´ before the = sign. Or a #NOMBRE# (in Spanish) error
