ssblue
asked on
Excel calculate based on 'x' in column
I would like to calculate the cost and calorie count based on using an ' x ' in column next to data.
see attachment with sample data
sample-data.xlsx
see attachment with sample data
sample-data.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
F1: ="Calories Total = " & SUMIF(F2:F20, "x", D2:D20)
G1: ="Cost Total = " & TEXT(SUMIF(F2:F20, "x", E2:E20), "$0.00")