Forum Discussion

Copper Contributor

Dec 11, 2022

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...

excel

Formulas and Functions

HansVogelaar
Dec 11, 2022
appletonthecat

=SUMPRODUCT(B2:B6,E2:E6)/SUM(B2:B6)

Format the cell with the formula as a percentage.

HansVogelaar

MVP

Dec 11, 2022

appletonthecat

=SUMPRODUCT(B2:B6,E2:E6)/SUM(B2:B6)

Format the cell with the formula as a percentage.

appletonthecat
Copper Contributor
Dec 11, 2022
HansVogelaar

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

Salty Costing Sheet 2022.xlsm138 KB
- HansVogelaar
  MVP
  Dec 11, 2022
  appletonthecat
  
  Not sure this is what you want (and you already marked PeterBartholomew1's reply as the answer), but see the attached workbook.
  Salty Costing Sheet 2022.xlsm136 KB
  - appletonthecat
    Copper Contributor
    Dec 11, 2022
    HansVogelaar
    
    Hey
    I hit the best reply by accident, what you gave me on the sheet is exactly what I was looking for
    
    thanks for the help
    
    cheers
    
    dave