Formula Needed

[drettmannc]

Hi I need assistance with an if statement formula that looks at a row and if 4 or more of the cells in that row range that spans across multiple columns are equal to a value then the statement is true.

Attached is a screenshot of the data. Need the formula to go into N4 - if the value of 4 or more cells in the range F4-L4 is equal to "High" then the statement is true if not false.

 

[Joe4]

Try this:

=COUNTIF(F4:L4,"High")>=4

 

[Fluff]

How about
=COUNTIF(F4:L4,"High")>3

beaten2it again

 

[drettmannc]

Thank you but I dont need to count I wanted to make the it so if the statement is true I wanted N4 to state "Yes" if false "No"

 

[Joe4]

Thank you but I dont need to count I wanted to make the it so if the statement is true I wanted N4 to state "Yes" if false "No"

I am guessing from your response that you didn't actually try the formula.
Try it out, and see what it returns (hint: it doesn't return the count!).

 

[drettmannc]

Ahh I see now! Sorry about that used what you provided me, tweaked it, and got exactly what I needed. =IF((COUNTIF(F4:L4,"High")>=4),"Yes","No")

 

[Joe4]

Yes, you original request said "True/False", so that is how I wroite the original formula.
Basically, we just created a boolean expression that returns true (if the count is greater than or equal to 4) or false (if it does not).

Also, you want to be sure to try the formula first before saying it doesn't work.