Extracing a specific numbers

Occasional Contributor

Hi, I need to extract a specific numbers and add.

Mascarello_0-1641950769296.png

 

 

1 Reply

@Mascarello 

=SUM(FILTERXML("<y><z>"&SUBSTITUTE(B2," ","</z><z>")&"</z></y>","//z"))