The sum of values in the next row

mpiza

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

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?).