Forum Discussion
Mitchyll
Apr 30, 2020Copper Contributor
Creating a formula for adding up values of cells if filled with "X"
Hello,
I was wondering if you could help me create a formula. I would like to have cell O9 be the overall total from G9, I9, K9, L9, and M9.
Cell G9 is a rate, which will be 18.
If cell I9 is labeled with an "X", I would like 1.50 added to O9
If cell J9 is labeled with an "X", I would like 2 added to O9
If cell K9 is labeled with an "X", I would like 2 added to O9
If cell L9 is labeled with an "X", I would like 1 added to O9
If cell M9 is labeled with an "X", I would like 3 added to O9
Basically, if there is an "X" in a cell(s) listed above, I would like that value(s) added to the base rate (G9) and displayed in cell O9
Thank you!
5 Replies
Sort By
- SergeiBaklanDiamond Contributor
- MitchyllCopper Contributor
Thank you! SergeiBaklan