how to count data with dates and use vlookup

[afriditigr]

Hi,
I have a long list with dates from google in the first comumn,
and in my third column I have dates from our database where customers made a registration in our website.
What I want to do in the second column(count-data) is : given the date in the first column, for example 12/7/2011 go to the third column and count the cells which have the dame date 12/7/2011, and then appear at the second column the counts.
I did it manually so far, and I failed to use countif and vlookup.
Do you have any suggestions,
Thank you

GOOGLE count-data DATABASE
12/7/2011 2 12/7/11
12/8/2011 1 12/7/11
12/9/2011 1 12/8/11
12/10/2011 2 12/9/11
12/11/2011 12/10/11
12/12/2011 12/10/11
12/13/11 12/12/11
12/14/11 12/12/11
12/15/11 12/12/11
12/16/11 12/12/11
12/17/11 12/12/11
12/18/11 12/13/11
12/19/11 12/13/11
12/20/11 12/13/11
12/21/11 12/14/11
12/22/11 12/15/11
12/23/11 12/17/11
12/24/11 12/24/11
12/25/11 12/24/11
12/26/11 12/25/11
12/27/11 12/25/11
12/28/11 12/25/11
12/29/11 12/27/11
12/30/11 1/4/12
12/31/11 1/4/12
1/1/2012 1/4/12
1/2/2012 1/5/12
1/3/2012 1/5/12
1/4/2012 1/5/12
1/5/2012 1/5/12
1/6/2012 1/7/12
1/7/2012

 

[Jubjab]

This should work with a simple COUNTIF. In cell B1 type

=COUNTIF(C1:C100,A1)

copy down

 

[afriditigr]

it works, thank you for the instant answer

 

[Jubjab]

This should work with a simple COUNTIF. In cell B1 type

=COUNTIF(C1:C100,A1)

copy down

Maybe you already corrected it, but the formula needs dollar signs for the lookup area, otherwise it might produce errors. I.e.

=COUNTIF($C$1:$C$100,A1)

 

[afriditigr]

yeah, I noticed it, Thanks