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

 

[Fluff]

Are you using this in xl365? as I cannot get that formula to return a #VALUE! error.

 

[AndyGav86]

Are you using this in xl365? as I cannot get that formula to return a #VALUE! error.

Yes, I am but I've just realised what the problem was, the sheet name was wrong it was "Office Tracker" but should have been "Officer Tracker"
My fault, so it is working thank you so much.
It does have a slight "error"? i think check the screenshot or can i just ignore the error as its working?
Sorry to keep asking but you have really been helpful

 

[Fluff]

You can happily ignore that error.
Glad you figured it out

 

[AndyGav86]

You can happily ignore that error.
Glad you figured it out

Thank you for your patience

 

[Fluff]

Glad to help & thanks for the feedback.

 

[RobP]

thats a Rookie mistake @Fluff.... even I got the right sheet name (just sayin' like..)