Forum Discussion
Solved
calculating abv in cocktails
Hey Guys,
I am trying to find a formula to calculate the ABV in a cocktail recipe using ML
column a Column b Column C Column d Column e
Spirit Quantity Unit Bottle Size ABV bottle
vodka 25 Ml 700 40%
gin 40 Ml 500 32%
rum 30 Ml 700 43%
Lime 25 Ml 700 0%
Sugar 25 ML 700 0%
total ABV per Cocktail?
cheers
dave
=SUMPRODUCT(B2:B6,E2:E6)/SUM(B2:B6)
Format the cell with the formula as a percentage.
Same formula (other than SUMPRODUCT which is no longer needed in 365); different style.
= LET( cocktailVolume, SUM(Quantity), cocktailAlcohol, SUM(Quantity*ABV_bottle), ABV, cocktailAlcohol / cocktailVolume, ABV )I have attached the sheet I am working on, as I am not sure how to use the formula you sent
tab salty cocktails
column j 28 for the total
thanks
=SUMPRODUCT(B2:B6,E2:E6)/SUM(B2:B6)
Format the cell with the formula as a percentage.
thanks for the quick response, but i just can't seem to get it to work, I have attached the sheet
tab salty cocktails
column J 28
cheers
dave
Not sure this is what you want (and you already marked PeterBartholomew1's reply as the answer), but see the attached workbook.
