Addition (Possible) ?

[Liaquat Ali]

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]

Can you give us a better example AND what outcome you would expect from that example ???

 

[Liaquat Ali]

Thanks Michael,

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

Cell Value

A1 = Adam 6
A2 = Wilson 4
A3 = Alice 5

A4 = 15

 

[Rick Rothstein]

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

Cell Value

A1 = Adam 6
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]

Many Thanks Mr. Rick