Sum values until the first time a condition is met

I was able to solve the problem using brute force but my system/Excel seems to struggle when trying to apply it to a large data set. I was wondering if anyone could provide any assistance with solving this problem in a more efficient computational way.

=IFS(U6<>$U$3,"",AB6=1,(F6-E6)/E6, AB7=1,(F7-E6)/E6, AB8=1,(F8-E6)/E6, AB9=1,(F9-E6)/E6, AB10=1,(F10-E6)/E6, AB11=1,(F11-E6)/E6, AB12=1,(F12-E6)/E6, AB13=1,(F13-E6)/E6, AB14=1,(F14-E6)/E6, AB15=1,(F15-E6)/E6, AB16=1,(F16-E6)/E6, AB17=1,(F17-E6)/E6, AB18=1,(F18-E6)/E6, AB19=1,(F19-E6)/E6, AB20=1,(F20-E6)/E6, AB21=1,(F21-E6)/E6, AB22=1,(F22-E6)/E6, AB23=1,(F23-E6)/E6, AB24=1,(F24-E6)/E6, AB25=1,(F25-E6)/E6, AB26=1,(F26-E6)/E6, AB27=1,(F27-E6)/E6, AB28=1,(F28-E6)/E6, AB29=1,(F29-E6)/E6, AB30=1,(F30-E6)/E6, AB31=1,(F31-E6)/E6, AB32=1,(F32-E6)/E6, AB33=1,(F33-E6)/E6, AB34=1,(F34-E6)/E6, AB35=1,(F35-E6)/E6, AB36=1,(F36-E6)/E6, AB37=1,(F37-E6)/E6, AB38=1,(F38-E6)/E6, AB39=1,(F39-E6)/E6, AB40=1,(F40-E6)/E6, AB41=1,(F41-E6)/E6, AB42=1,(F42-E6)/E6, AB43=1,(F43-E6)/E6, AB44=1,(F44-E6)/E6, AB45=1,(F45-E6)/E6, AB46=1,(F46-E6)/E6, AB47=1,(F47-E6)/E6, AB48=1,(F48-E6)/E6, AB49=1,(F49-E6)/E6, AB50=1,(F50-E6)/E6, AB51=1,(F51-E6)/E6, AB52=1,(F52-E6)/E6, AB53=1,(F53-E6)/E6, AB54=1,(F54-E6)/E6, AB55=1,(F55-E6)/E6, AB56=1,(F56-E6)/E6, AB57=1,(F57-E6)/E6, AB58=1,(F58-E6)/E6, AB59=1,(F59-E6)/E6, AB60=1,(F60-E6)/E6, AB61=1,(F61-E6)/E6, AB62=1,(F62-E6)/E6, AB63=1,(F63-E6)/E6, AB64=1,(F64-E6)/E6, AB65=1,(F65-E6)/E6, AB66=1,(F66-E6)/E6, AB67=1,(F67-E6)/E6, TRUE,(F68-E6)/E6)

There are two main conditions, the primary one, which if met, #(reference cell) vs 0, then I want sum the number of values from that point until a second condition is met to stop the summing (which will also be a 1 vs 0). In this example, stopping at summing ~62 cells is an arbitrary stop point based on the limitations of IFS function.

The other issue is that the value to indicate to stop summing can occur multiple times within the possible summing range and I only want to sum until the stop condition is met the first time.

Thanks in advance.

Steven

MarvinP,

Thanks for the response. I was able to use what you provided to figure out the solution with some tweaking. I ended up having to use OFFSET function but it all worked out.

Thanks again for taking your time to help me out.

Appreciate it!

Steven