Need Help to SUM First NON_BLANK Cell

[HotNumbers]

Need Help to Sum 12 columns from the first non blank cells that appear only after a certain criteria is meet. The Data columns are from Column G:AP. The Criteria that I need are in Columns BD and BE. The formula will be in BF. Here is what I need

If BD is Blank and BE is (Burbank or ESCO) then I need it to sum 12 columns from the first non Blank Cell if There is data in BD and BE then I want

IF(ISERROR(SUM(INDEX(G96:BC96,MATCH(BD96,NC_FY_PERIODS,0)-3):INDEX(G96:BC96,0,MIN(MATCH(BD96,NC_FY_PERIODS,0)+14)))),"",SUM(INDEX(G96:BC96,MATCH(BD96,NC_FY_PERIODS,0)-3):INDEX(G96:BC96,0,MIN(MATCH(BD96,NC_FY_PERIODS,0)+14))))

 

[HotNumbers]

How can I JOIN THese Two separate formuls into one? They Both work on there own, However I need to combine it to work

=IF((BD2="")*(OR(BE2={"Burbank","Esco"})),SUM(INDEX(G2:BB2,MATCH(TRUE,INDEX(G2:BB2<>"",0),0)):INDEX(G2:BB2,MATCH(TRUE,INDEX(G2:BB2<>"",0),0)+11)),"")


IF(ISERROR(SUM(INDEX(G96:BC96,MATCH(BD96,NC_FY_PERIODS,0)-3):INDEX(G96:BC96,0,MIN(MATCH(BD96,NC_FY_PERIODS,0)+14)))),"",SUM(INDEX(G96:BC96,MATCH(BD96,NC_FY_PERIODS,0)-3):INDEX(G96:BC96,0,MIN(MATCH(BD96,NC_FY_PERIODS,0)+14))))

 

[Domenic]

I'm assuming that this part of the formula...

MIN(MATCH(BD2,NC_FY_PERIODS,0)+14)

...should actually be...

MIN(MATCH(BD2,NC_FY_PERIODS,0),14)

If this is the case, try the following...

=IF((BD2="")*(OR(BE2={"Burbank","Esco"})),SUM(INDEX(G2:BC2,MATCH(TRUE,INDEX(G2:BC2<>"",0),0)):INDEX(G2:BC2,MATCH(TRUE,INDEX(G2:BC2<>"",0),0)+11)),IF((BD2<>"")*(BE2<>""),SUM(INDEX(G2:BC2,MATCH(BD2,NC_FY_PERIODS,0)-3):INDEX(G2:BC2,0,MIN(MATCH(BD2,NC_FY_PERIODS,0),14))),""))

Hope this helps!

 

[HotNumbers]

Thanks. Will give a try