sum only right part (number part) of the cells

[jojo1]

Hi
please could anyone tell me how to sum only right part of the cell (which always will be one or two digits number ) along one row but many columns

B4 C4 D4
Fri 02/01/2015 , 5 Thu 01/01/2015 , 12 Sat 05/01/2015 , 3



thanks
Jo

[zbor]

based on the example try this.
Confirmed with ctrl+shift+enter (not just enter)

Please Login or Register  to view this content.

[Jonmo1]

Is there ALWAYS a space between the comma and the number?

Try
=SUMPRODUCT(RIGHT(0&B4:D4,2)+0)

[zbor]

Note: if you have entered only date (or any other number that you don't want to SUM) you'll get a wrong result.
Rather put some text at the end to avoid that.

[jojo1]

Thanks so much, both options work.
I tried SUMPRODUCT but obviously did it wrong.
I will be a frequent guest of this forum, I got problems all the time

[Jonmo1]

You're welcome.