How to add multiple numbers in a cell

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
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Panhia Vang 

    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:

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!