Forum Discussion

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

excel

Formulas and Functions

wumolad

Iron Contributor

Apr 30, 2020

Hi Mitchyll

This should be fine.

=G9+((I9="X")*1.5)+((J9="X")*2)+((K9="X")*2)+((L9="X")*1)+((M9="X")*3)

Cheers

Mitchyll

Copper Contributor

May 01, 2020

Thank You!

wumolad

wumolad
Iron Contributor
May 01, 2020
Mitchyll

You are welcome