Hi all. I'm working with a bit of a funky template that was given to me. Each cell has option of NA, X, or a number that's attributed to it. My question to you all is how do I find a sum of only the numbers? I tried to find the sum of the column without any other sort of equation but all of the results were just zero and I have a feeling it's because of the text in the data. Any help would be much appreciated. Thank you!

Scott