Countif formula help please

Hi Excel Forum Members
I've been struggling with the following problem.

i'm trying to figure out formulas that will
1: count how many times a date appears is a set of numbers
2: add together the values associated with the date

I hope i've explained it. Ive attached an example and also the table i'm trying to complete. I have manually completed the outcome table but i'm after formulas that will do this work automatically. it is also possible to have h6 and i6 reference g6?

Thank you in advance
Callum

Hi sorry i'll try again with the attachment!

third time is a charm!
http://www.2shared.com/file/Y34fZJR8/Book1.html

The trouble i'm having with the countif is i'm searching for a cell containing a date

Thanks

Hi Teylyn
i can't get it to work! but i keep trying

this is a selection from the date range
28/02/2011 14:34
24/02/2011 11:21

and i'm using this function with g6 refering to a date cell below
=SUMIF(A2:A24,G6,B2:B24)


28/02/2011
24/02/2011

how can i get the sumif formula to search within the cell contents and disregard the time?

Thanks
Cal

Hi Guys

Thank you so much for your help i've got one more question

if this is my formula

=COUNTIF(A2:A24,G6)

If i have a cell H2 contains A2:A24 can i like the formula to look at cell H2 for the range?


Thanks