Hi, i am very beginner in excel. I have a dedicated cell where randomly placing values by user to search results from a range. And I want to use another cell by using countif formula to see how many times the thing occurs within that range but my formula criteria is that randomly placing dedicated cell. I tried =COUNTIF(C4:J1215,"B2") but result is 0. What else should I do here to get the result?
If i fail to make YOU understand then plz let me know, i will attach a snap then.
Thanks in advance.