Sum

[emvella]

Hi,

How can I paste numbers with dash in between like the ones below and it calculates the total 37? In other words I want a formula that it removes the dash and calculate all the numbers together 2+2+4+2+2 etc....

2-2
4-2
2-0
1-2
1-1
2-3
6-0
3-1
3-2
___
37

Thanks

 

[sandy666]

Text2Columns
then:

	A​	B​	C​	D​	E​
1​	2-2	2​	2​	4​	=SUM(B1:C1)
2​	4-2	4​	2​	6​
3​	2-0	2​	0​	2​
4​	1-2	1​	2​	3​
5​	1-1	1​	1​	2​
6​	2-3	2​	3​	5​
7​	6-0	6​	0​	6​
8​	3-1	3​	1​	4​
9​	3-2	3​	2​	5​
10​				37​	=SUM(D1:D9)

 

[JustynaMK]

Hi,

If you have your range in cells A1:A9 and they are formatted as text, you can use the following:
=SUM(VALUE(LEFT(A1:A9,1)),VALUE(RIGHT(A1:A9,1)))
Enter it using Ctrl+Shift+Enter

Hope it helps!

 

[Peter_SSs]

.. or with standard entry
=SUMPRODUCT(LEFT(A1:A9,FIND("-",A1:A9)-1)+REPLACE(A1:A9,1,FIND("-",A1:A9),""))

If we knew they were always single digits then it reduces to
=SUMPRODUCT(LEFT(A1:A9)+RIGHT(A1:A9))

 

[emvella]

Hi Guys,

That's perfect.

Thank you all.

 

[Peter_SSs]

Hi Guys,

That's perfect.

Thank you all.

Glad you got a successful outcome.