Thanks for your help, you three. Unfortunately, none of the formulas are
working! I am doing a cut and paste right into my formula bar, but I am
getting a VALUE error.
Here are some specifics of my entries:

My cell range is D5:Q5, and the cell entry could be [A#], or [S#] (where #
is a digit 1-9). I have two cells at S5 and V5 (A and S values,
respectively) that I want the # values summed up.

I was trying IF and VALUE and RIGHT statements, but I can't get those to
work either. Thanks for helping!

"PageRow" wrote:

I am trying to add up numbers in cells that have letters in them. My problem
is that there are two types of letters, and I want them to be added in an
adjacent cell. Confusing? Yeah.

OK, I want to add up the numbers from a row into two columns: "A" and "S".
The user will input, say "A8", "S3", and "A4" in one row. I need a formula to
recognize the difference and give an output of "12" in the "A" column, and
"3" in the "S" column.

I've tried VALUE and RIGHT, but it won't let me do a range of cells, or
recognize the difference between "A" and "S".

Thanks