How to get the count for the given data

[mithelesh]

Hi all ,

Can u please suggest or help me how to count the data as metnioned in the file.

Required Info as mentioned below:

Count Date
3 3/27/2014
3 5/21/2014
2 9/21/2014

Thanku
Mithelesh.S

 

[srinidhi]

=COUNTIF(B2:B10,B15)

 

[srinidhi]

=COUNTIFS($B$2:$B$10,B15,$A$2:$A$10,">a")

 

[mithelesh]

Thanku for the reply .

Mithelesh.S

 

[Khalid NGO]

Hi mithelesh,
you can also try simple countif:
=COUNTIF($B$2:$B$10,B15)
Copy down

Regards,