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 Un...
=SUMPRODUCT(B2:B6,E2:E6)/SUM(B2:B6)
Format the cell with the formula as a percentage.
=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.
Hey
I hit the best reply by accident, what you gave me on the sheet is exactly what I was looking forthanks for the help
cheers
dave
Your formula worked for me and was actually more robust when it came to the blank strings returned by VLOOKUP. My formula was happier with zeros.
