Text to Value Summation

[Dkendr02]

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 in each cell is = to ‘1’ and S2:V2 where the value of any text in each cell is = to ‘.6’. A blank cell would have no value.

For example, If L2, M2, and N2 had the words RED (with O2-R2 empty) and S2 and T2 had the words BLUE (with U2-V2 empty), J2 would = 4.2

Thank you in advance for the help!

 

[Joe4]

Welcome to the Board!

Try this:

=COUNTIF(L2:R2,"<>")+(COUNTIF(S2:V2,"<>")*0.6)

 

[BobUmlas]

Ctrl+Shift+Enter:
=SUM(1*(L2:R2<>""),0.6*(S2:V2<>""))

 

[Fluff]

Another way
=COUNTA(L2:R2)+COUNTA(S2:V2)*0.6

 

[Dkendr02]

That did the trick....Thank you!!

 

[Joe4]

You are welcome.