Try these:

Both are array formulas. Entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER):

=SUM(IF(LEFT(A1:A4)="S",MID(A1:A4,3,10)+0))

=SUM(IF(LEFT(A1:A4)="V",MID(A1:A4,3,10)+0))

Biff

"Shirley" wrote in message
...
I don't know if this is possible, but thought it was worth asking. Is
there
a function in excel where it will add the numbers in a cell based on the
text
that's in it? For example, here's what I want to do:

A1: S=8.0
A2: (blank)
A3: V=8.0
A4: S=4.0

Based on the cells listed above, what formula can I use to get the
following?

S=12.0
V=8.0

Thanks in advance!