So, I'm wanting to count the number of cells in a row (U5:X5) that contain TRUE, and if the range contains 3 or more instances of TRUE, I want to mark the cell TRUE, showing that yes, there are 3 or more instances of TRUE in the range.

What I have so far is not working...

=IF(COUNTIF(U5:X5,"TRUE") >= 3,"TRUE","")

Here's a

CodePudding user response：

I removed the quotation marks around the TRUEs in your formulas and entered the following in J2:

=ArrayFormula(IF(A2:A="",,MMult(N(F2:I),{1;1;1;1})>=3))