Forum Discussion
Trivia Score Sheet
What I'm trying to accomplish is having the letter w to represent a word, but also having a numerical value with it like 6w But here is the tricky part of it, I need to have that numerical ...
wyoung1969 , thank you.
It's unclear what to do if you have any other text after the number except w. Like in case of 1(1). If ignore as in the sample
formula could be
=SUMPRODUCT(1*IFERROR(SUBSTITUTE(LOWER(C4:E4),"w","")+0,0))You may also highlight cells with w by conditional formatting rule with formula
=RIGHT(C4)="w"
Ok, now on the formula, is there a way to do a mast input it in columns G, from rows 4 - 50
Copy/paste the formula into G4 and drag this cell down till G50. Or, after the formula is pasted, select G4:G50 and Ctrl+D.