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!