Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Use these formulas...

F1: ="Calories Total = " & SUMIF(F2:F20, "x", D2:D20)
G1: ="Cost Total = " & TEXT(SUMIF(F2:F20, "x", E2:E20), "$0.00")