SUM without text

[ml1990ml]

Hello,

I would like to sum numbers from each column for example B18:B28 in cell at the bottom. I have a problem with number 240, otherwise i would use RIGHT;2. I use excel 2010, windows 7. Please for suggestions.

Example:

tmpp-60	igra-240
igra-240	thpi-30
ths-60	thpa-60
dpa-30	thpar-30
	ths-60
=?	=?

<tbody>
</tbody>

 

[caabyyc]

1. Enter following in A6, then press SHIFT+CTRL+ENTER (array formula)

=SUM(IF(A1:A5<>"",MID(A1:A5,FIND("-",A1:A5)+1,999))-0)
2. then drag it to B6(copy)

Hello,

I would like to sum numbers from each column for example B18:B28 in cell at the bottom. I have a problem with number 240, otherwise i would use RIGHT;2. I use excel 2010, windows 7. Please for suggestions.

Example:

tmpp-60	igra-240
igra-240	thpi-30
ths-60	thpa-60
dpa-30	thpar-30
	ths-60
=?	=?

<tbody>
</tbody>

 

[circledchicken]

Hi and welcome to the forum,

Perhaps try something like this (you need to press CTRL-SHIFT-ENTER rather than just ENTER as it is an array formula):

=SUM(
    IFERROR(
      --REPLACE(B18:B28, 1, FIND("-", B18:B28), ""),
      0))

 

[ml1990ml]

aaa, thanks both of u, works perfectly. i was losing my mind :D Cheers