How can I write a formula that will count the number rows that meet a condition in one of the columns? I found this to work in Excel:=SUM(N(MMULT(N(N2:DD14>2.5),ROW(INDEX(A:A,1):INDEX(A:A,COLUMNS(N2:DD14)))^0)>0))But how can I get something like this to work in Google Sheets?
Counting rows where condition is met in at least one column
google spreadsheets