CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
user14915635
user14915635

Reputation: 396

Count and Mark TRUE if Range in a Single Row Contains 3 or More Instances of TRUE

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 Google Sheet that you can edit.

Thanks for your help!

Upvotes: 0

Views: 557

Answers (2)

z..
z..

Reputation: 12993

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))

Upvotes: 1

basic
basic

Reputation: 11968

Use:

=COUNTIF(A5:F5,TRUE)>=3

enter image description here

Upvotes: 2

Related Questions