How to add multiple numbers in a cell

Panhia Vang · 07/03/21

Hi all,

How do I add the numbers in a single cell together like this?

If it says

Run 1 - 20

Run 2 - 20

I want to get the sum of the 20's or 19's only

Bassam Khalil · 07/04/21

Hope you are fine, you need to add a helper column to extract numeric values as per your filter then you can sum it. use the following formula

=MID(Origin@row, FIND("-", Origin@row) + 1, 10)

the following screenshot shows the result:

Answers