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".
Answers

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
Categories
Check out the Formula Handbook template!