Hi

If your input is in D2 to F2, try this in A2
=SUMPRODUCT((LEFT(D2:F2,1)="A")*(RIGHT(D2:F2)))
and this in S2
=SUMPRODUCT((LEFT(D2:F2,1)="S")*(RIGHT(D2:F2)))

Hope this helps.
Andy.

"PageRow" wrote in message
...
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