I am trying to use a countif statement but I want don't want to look at a whole range just certain cells. I have tried different things but I keep getting an error. Here is something like I am trying.
I just want to look at cells T17, T20 and T30 but nothing in between.
=IF(COUNTIF((T17,T20,T30),"X")>0,"X","no")
If you have any suggestions let me know.
Thanks-
I just want to look at cells T17, T20 and T30 but nothing in between.
=IF(COUNTIF((T17,T20,T30),"X")>0,"X","no")
If you have any suggestions let me know.
Thanks-