Can somebody please help me fix my =IF statement?

[Milos]

Hi all,

I have an IF statement that is not working and I am after someone with more knowledge than I have to help me fix it, or make another formula to the same effect.

My statement is trying to perform some quick stats to identify start progress. The two letter words are the initials of my co-workers and they update this tracking sheet a couple of times a day. I want to be able to search the columns H:K for their initials and easily filter for how many of the rows have been started.

This is the formula I have so far:

=IF(OR(ISNUMBER(SEARCH("HS",H3:K3)),ISNUMBER(SEARCH("NT",H3:K3)),ISNUMBER(SEARCH("KR",H3:K3))),"Started","Not started")

Thanks,
Milos

 

[Marcelo Branco]

Try

=IF(SUM(COUNTIF(H3:K3,{"HS";"NT";"KR"})),"Started","Not Started")

Hope this helps

M.

 

[Milos]

Perfect it helps a lot! Thanks Marcelo!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.