G
Guest
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
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