Conditional Range, If Statements, and Sum

[ljone153]

I want to create a macro that sums up the numbers for both "1" and "3" separately in the second column only between the range of "S" and "N" in the first column. I want to be able to do this for multiple section without having to do all of it manually. I think I added a picture, hopefully it shows up.

 

[ljone153]

https://drive.google.com/file/d/181j7LpoXFvckonk0DGa0DodrftAedaW3/view?usp=sharing

Here is the link since it seems to not have shown up on the forum. Let me know if there is any issues!

 

[ljone153]

I think I should also clarify that I am trying to sum up the third column. Also, I want the range for the sums to go to the last "N", not the first "N" because there can be multiple "N"s per section. I want to macro to stop running once "Stop" is reached.