Data Text to Columns select Delimited Next select Other then enter =
in the square box Finish
Then =SUM(B1:B4)


"Shirley" wrote:

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!