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 ,, MalajeMalaviaMalapipaCanibal ChardFlorMalvajioCanibal TintoVermutNaranjaEspumosoTotalBottlesBottle Sales 28111 12151212 224 13116 112217 12227 33 341513 ...
