I've been tinkering with microsoft excel, and I am trying to figure out how to do something.
I know how to set a cell to add up the total of a range of cells filled with digits, but I am trying to figure out how to assign a numerical value to a letter to do the same.
for example, if I enter the letter X into a cell, it automatically counts as the number 1, and likewise, if I enter a letter Y, it counts as a 0.
from there, I want to set my "total" cell to add up the total and output it as a numerical value based on the selected cells and their contents.
dunno if it makes sense, I always find these things harder to explain than it is to think about them.
anyone here know how to do this?
I know how to set a cell to add up the total of a range of cells filled with digits, but I am trying to figure out how to assign a numerical value to a letter to do the same.
for example, if I enter the letter X into a cell, it automatically counts as the number 1, and likewise, if I enter a letter Y, it counts as a 0.
from there, I want to set my "total" cell to add up the total and output it as a numerical value based on the selected cells and their contents.
dunno if it makes sense, I always find these things harder to explain than it is to think about them.
anyone here know how to do this?