Your current formula works but it's an "array formula" and, as such, it needs to be "array entered". Select cell with formula, press F2 key to select formula and then hold down CTRL and SHIFT keys while pressing ENTER. If done correctly then curly braces like { and } will appear around the formula
....or you can try this non array version
=0+(SUMPRODUCT((C2:J2>45)+(M2:T2>45))>0)
Bookmarks