Text to Value Summation

Here is what i am trying to do….is there one formula that would work?

In J2, I want to sum L2:R2 where the value of any text is = to ‘1’ and S2:V2 where the value of any text is = to ‘.6’. A blank cell would have no value.

 

For example, If L2, M2, and N2 had the words RED and S2 and T2 had the words BLUE, J2 would = 4.2

Thank you in advance for the help!

By: David

Leave a Reply

Your email address will not be published. Required fields are marked *