I want a Google sheets formula along the lines of
I.e., for each of the rows 4-150 (column A is not relevant), if the sum of columns E-J in that row is <132 and the sum of columns E-K in that row is >=132, then count that row with 1; in the end return the amount of rows that satisfy the condition.
count = 0 for 4 <= i <= 150: if (sum(Ei:Ji)<132 and sum(Ei:Ki)>=132): count = count+1 return count
countif does not accept complex conditions. I've been fiddling around with
arrayformula and nestings of
countif for a while but can not find out which combination yields me the desired function structure that iterates over all rows, then checks the sum over a column range relative to that row and counts the result.