Translating Xs to number values

Hi all, just found this board trying to research a solution. I have a spreadsheet with two worksheets, "Questions" and "Scoring". Questions is a Likert (5-point) scale for people to rate their agreement with various statements. They will rate by placing an "X" under their level of agreement. I need to translate the X into a number value on the "Scoring" worksheet. ("Strongly Agree" = 5, "Mostly Agree" = 4, etc.)

On the "Scoring" worksheet I want a function that says "if X exists in this cell put a 5 here; but if X exists in this cell put a 4 here; but if X exists in this cell put a 3 here" etc. All of said cells are within the same row.

I can get it to properly function for a single cell with =IF(Questions!$C9="X","5","")

With that, if "X" is placed under the Strongly Agree column, it reports a 5 back and if X is placed anywhere else the cell is blank. I've tried what I can think of to make it also work for the 4 other possible numerical values, but I can't get it quite right.

I was told to try: =IF(ISERROR(FIND("x",Questions!C9)),"5",IF(ISERROR(FIND("x",Questions!D9)),"4")) and test to see if it correctly reported a 4 or 5 (and if so, copy the logic for 3 - 1). It actually reports a 5 regardless of where the X is.

I've done a lot of single variable things, and I simply have no idea how to add in the "or if this then this, or if this then this, or if this then this" logic.

Any help is greatly appreciated!

Thank you for the replies!

ConnieXionLost: I tried that (in my case it became =COUNTIF(Questions!$C9:G9,"X")*5) What that does is basically add 5 any time there's an X for any value. So I tested it by placing an X in the cell that' worth 1 and it gave me 5. I placed an X in another cell and it gave me 10. I removed all Xs and it gave me 0.

Tony Valko: They go from 5 to 1. I'm using word values of Strongly Agree (which should be worth 5), Mostly Agree (worth 4), Agree (worth 3), Mostly Disagree (worth 2), and Strongly Disagree (worth 1).

Ace_XL: Will try that right now...

Ace_XL: I feel kind of stupid reporting this, but all I can get from that is the actual function displayed in the cell. I've made sure there was no ' at the start, and that the initial = was there, I've made sure the cell was empty, tried pasting it, typing it, and even using the "wizard" to select =IFERROR and typing it out that way.

Do IFERROR functions need to be ended in some way other than the standard <Enter>? (I've read about some that need ctrl+shift+enter or something like that)

I've attached the spreadsheet (no functions at all) that I'm working with, for reference -- if I understood the upload utility, that is!

Edited to add: on the Scoring worksheet, "answer 1" means the numerical value for the first question goes there; "answer 29" means for the 29th question, etc.