Auto fill

[dwarek]

Hello Everyone
I have been assigned a task to create a auto fill function. The task is I need to create a formula to search a particular alpha numeric word in a column and define how many times this word as appeared in that column. For example lets say a alpha numeric word called "MIKE1" in column A. In cell B2 I need to write a formula how many times "MIKE1" has appeared. So if this word as appeared 12 times in column A then I need the value 12 in cell B2. Can anyone help me out in this. Thanks in advance

 

[Fluff]

Try
=COUNTIF(A:A,"Mike1")

 

[dwarek]

hey
Thank you It works fine and I have another question. I have a column with dates and I want to count cells filled with January. For example lets say in column B is filled with dates in DD/MM/YYYY format. Is there any way to find out how many cells are filled for particular month for example in Jan ?
Thank you so much in advance

 

[Fluff]

Something like
=SUMPRODUCT(--(MONTH(B2:B18)=1))

 

[dwarek]

Hey
No its not working it shows #VALUE !

 

[Fluff]

Works for me, are you sure that your dates are real dates, not text.

 

[dwarek]

yea its in DD/MM/YYYY format

 

[dwarek]

The point is I have same date for different cells for example 21/01/2019 is from B10 to B15 so it should not count as duplicate

 

[Fluff]

Double check your dates, if you are getting #Value! it's probably because you have text in the range

 

[dwarek]

hey
it works now but it gets the value of the empty cell as well, any idea how to resolve this ?