#### Liaquat Ali

##### New Member
Hi,
I have Data Sheet of a students, in which serial number and name of each student are given together in one cell.
Is it possible to add only serial number of all?

 ABC School Class VI Students 1 xxxx 2 xxxx 3 xxxx 4 xxxx 5 xxxx 6 xxxx 7 xxxx 8 xxxx 9 xxxx 10 xxx ----------- Total

<tbody>
</tbody>
================

Thanks

#### Michael M

##### Well-known Member
Can you give us a better example AND what outcome you would expect from that example ???

#### Liaquat Ali

##### New Member
Thanks Michael,

I only want to calculate the numeric value of A1+A2+A3.

Cell Value

A2 = Wilson 4
A3 = Alice 5

A4 = 15

#### Rick Rothstein

##### MrExcel MVP
I only want to calculate the numeric value of A1+A2+A3.

Cell Value

A2 = Wilson 4
A3 = Alice 5

A4 = 15
Give this formula a try...

=SUMPRODUCT(0+TRIM(RIGHT(SUBSTITUTE(A1:A3," ",REPT(" ",99)),99)))

#### Liaquat Ali

##### New Member
Many Thanks Mr. Rick

1,082,343
Messages
5,364,794
Members
400,815
Latest member
gangstar67

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...