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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!