If but with a twist:(
 

I have 6 columns each cell has a value either “Ok” or “Problem”. I
would like to figure out how to automate on column 7 if I have three
“Ok” in my row then type “OK” if I have less than 3 OK in my row then
type “Problem”
A1 B1 C1 D1 E1
F1 G1
1 Ok Ok Problem Problem Problem Problem Problem
2 Ok Problem Ok Ok Problem Ok
Ok

If but with a twist:(
 

try:
=If(CountIf(A1:F1, "OK")=3, "OK", "Problem")


"AVB Over My Head" wrote:

I have 6 columns each cell has a value either €œOk€� or €œProblem€�. I
would like to figure out how to automate on column 7 if I have three
€œOk€� in my row then type €œOK€� if I have less than 3 OK in my row then
type €œProblem€�
A1 B1 C1 D1 E1
F1 G1
1 Ok Ok Problem Problem Problem Problem Problem
2 Ok Problem Ok Ok Problem Ok
Ok

If but with a twist:(
 

i think it would be =if(countif(a6:F6,:"ok")=,"ok","Problem")
This would make it greater or equal to three ok's.

"JMB" wrote:

try:
=If(CountIf(A1:F1, "OK")=3, "OK", "Problem")


"AVB Over My Head" wrote:

I have 6 columns each cell has a value either €œOk€� or €œProblem€�. I
would like to figure out how to automate on column 7 if I have three
€œOk€� in my row then type €œOK€� if I have less than 3 OK in my row then
type €œProblem€�
A1 B1 C1 D1 E1
F1 G1
1 Ok Ok Problem Problem Problem Problem Problem
2 Ok Problem Ok Ok Problem Ok
Ok

If but with a twist:(
 

Yep, I overlooked the =. Thanks for the correction

=if(countif(a6:F6,:"ok")=3,"ok","Problem")


"Steven Terry" wrote:

i think it would be =if(countif(a6:F6,:"ok")=,"ok","Problem")
This would make it greater or equal to three ok's.

"JMB" wrote:

try:
=If(CountIf(A1:F1, "OK")=3, "OK", "Problem")


"AVB Over My Head" wrote:

I have 6 columns each cell has a value either €œOk€� or €œProblem€�. I
would like to figure out how to automate on column 7 if I have three
€œOk€� in my row then type €œOK€� if I have less than 3 OK in my row then
type €œProblem€�
A1 B1 C1 D1 E1
F1 G1
1 Ok Ok Problem Problem Problem Problem Problem
2 Ok Problem Ok Ok Problem Ok
Ok