On column A I have dates (mmmm dd, yyyy), on column B I have names (John Doe)
and on column C I have ammounts ($0.00).

On a seperate worksheet inside the same workbook, I would like to sum the
ammounts per name, if they equal to =Today().

For example,

A B C
1 July 20, 2009 John Doe $20
2 July 20, 2009 Jane Doe $10
3 July 28, 2009 John Doe $5
4 July 28, 2009 John Doe $20
5 July 28, 2009 Jane Doe $30
6 July 28, 2009 Jane Doe $10

July 28, 2009 ( =Today() )
John Doe - $25
Jane Doe - $40


Hope I got my idea through....