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?

[TABLE="width: 191"]
<tbody>[TR]
[TD][/TD]
[TD]ABC School[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Class VI Students[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]4 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]5 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]6 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]7 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]8 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]9 xxxx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]10 xxx
-----------[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
================


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