cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Extracing a specific numbers

Mascarello
Copper Contributor

‎Jan 11 2022 05:27 PM

‎Jan 11 2022 05:27 PM

Extracing a specific numbers

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

Mascarello_0-1641950769296.png

 

 

422 Views
0 Likes
1 Reply
Reply
1 Reply
Detlef Lewin

‎Jan 11 2022 06:15 PM

‎Jan 11 2022 06:15 PM

Re: Extracing a specific numbers

@Mascarello 

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

 

0 Likes
Reply