You show the data in date order - assuming this to be the case with
the real data, you can use this in D1:

=IF(A1=A2,"",SUMIF(A:A,A1,C:C))

then copy this down as far as you need.

Hope this helps.

Pete

On Apr 27, 7:18*pm, MonkOnAMission
wrote:
Hi,
Coloum A has dates and Coloum B has productivity numbers (no of tasks
completed). Coloumn C contains the names of the tasks. The catch is:
duplicate dates - each day would have about 10 to 20 unique names while each
name would correspond to a numerical value.
Question: How can I get the sum (in coloum D) for each day, if there are no
blank rows in between any rows of consequtive days?

* * * * * * * * *A * * * * * * * * B * * * * * * C * * D
1 * * * 4/22/2009 * * * violet *14 * * *
2 * * * 4/22/2009 * * * indigo *17 * * *
3 * * * 4/22/2009 * * * blue * * * * * * *9 * * 40
4 * * * 4/23/2009 * * * green * 14 * * *
5 * * * 4/23/2009 * * * yellow *12 * * *
6 * * * 4/23/2009 * * * orange *16 * * *
7 * * * 4/23/2009 * * * red * * * * * * 14 * * *
8 * * * 4/23/2009 * * * apple * 14 * * *
9 * * * 4/23/2009 * * * mango * 14 * * *84
10 * * *4/24/2009 * * * fruit * * * * * 9 * * *
11 * * *4/24/2009 * * * biscuit * 8 * *
12 * * *4/24/2009 * * * coke * *14 * * *31