HotNumbers
Well-known Member
- Joined
- Feb 14, 2005
- Messages
- 732
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))))
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))))