Computer Hope

Software => Computer software => Topic started by: tasfin on April 27, 2020, 06:22:11 AM

Title: countif formula help
Post by: tasfin on April 27, 2020, 06:22:11 AM

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.

Title: Re: countif formula help
Post by: Term_ite on April 27, 2020, 11:51:47 AM

Hi Tasfin
It appears that you are placing the cell that you want the results of your search to appear in is part of the range you are searching. The cell that results of the search appear in must be outside of the range of cells that are being searched. See the attached JPG File.
Cell A1 = the cell that user places random values to be searched
Cell B2 = The cell that contains the formula
Cells C4-J17 = Range of cells being searched
Hope this helps.

Title: Re: countif formula help
Post by: tasfin on April 28, 2020, 12:15:49 AM

I am happy to see this prompt reply and its worked. Thanks a lot. :)