COUNTIFS? if one word appears in a row?

[AndyGav86]

Hi so I'm trying to count in the 4 Bag Test column under Fail, (sheet: Performance Review - H5) if on (sheet: Officer Tracker - G5:J5)
That if they fail even one bag or more out of A, B, C or D that it will count 1 fail in H5 in performance review sheet.

Hope that makes sense and thank you as always, all you guys are incredible

 

[RobP]

Hi, is this what you need to put in your Col H.

=IFERROR(COUNTIF(Officer Tracker!G1:J1,"Fail")/COUNTIF(Officer Tracker2!G1:J1,"Fail"),0)

essentially divide it by itself.

 

[Fluff]

Another option

=SIGN(COUNTIFS('Office Tracker'!G5:J5,"Fail"))

 

[AndyGav86]

Hi, is this what you need to put in your Col H.

=IFERROR(COUNTIF(Officer Tracker!G1:J1,"Fail")/COUNTIF(Officer Tracker2!G1:J1,"Fail"),0)

essentially divide it by itself.

Unfortunately, that didn't work.
Also, I need it to work for the whole column and all the officer names

 

[AndyGav86]

Another option

=SIGN(COUNTIFS('Office Tracker'!G5:J5,"Fail"))

Unfortunately, that didn't work.
Also, I need it to work for the whole column and all the officer names

 

[Fluff]

In what way didn't they work?

 

[AndyGav86]

In what way didn't they work?

So if i put fail in under Bag B it still shows an #VALUE!

 

[Fluff]

What do you mean by

it still shows an #VALUE!

There was no mention of any errors in your op & neither of the two suggestions should return that error.

 

[AndyGav86]

What do you mean by

There was no mention of any errors in your op & neither of the two suggestions should return that error.

Putting that formula in gave me the error

 

[AndyGav86]

What do you mean by

There was no mention of any errors in your op & neither of the two suggestions should return that error.