Forum Discussion

Mitchyll's avatar
Mitchyll
Copper Contributor
Apr 30, 2020

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

Resources