The sum of values in the next row


Hello everyone,

I'm having difficulty writing a formula and would like to ask for your help. If in the fourth column of the image below, a risk condition has been identified, I would like to sum the values below the row where the risk was identified, without including the row classified as a risk in a new column right after. However, I don't know how to do this sum.

Any ideas would be greatly appreciated.

In the example, what I expect is a result of 45 in a column next to "Risk".



  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭

    Hello @mpiza

    Would you be so kind as to letting us know the name of the column with the numbers?

    Also, please let us know if there is a possibility of 'Risk' showing up in another row below the first 'Risk'

    If so, please let us know if you only want the sum of numbers between each 'Risk', or the whole column of numbers subsequent to each 'Risk' (i.e., if 'Risk' showed up in the orange '0' row, would the number still be 45 next to the first 'Risk', or just 24?).

    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!