I am using the following array formula
=MATCH(1,(B10:H10+B15:H15>100)*(COLUMN(B1:H1)<>COLUMN(C1)),0) and was
wondering what would be the syntax that would allow me to ignore more than
one column (let's say "E").

Also, was wondering if there is a way to write the formula so that in
addition to avoid reviewing column "c" in the above formula there is a way to
avoid having return "2" it doesn't count it (i.e., if a match is found in
column "d" then instead of returning the number "3" it returns "2" because
"c" doesn't count). Thanks again