Please HELP!

[MonkOnAMission]

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

 

[Pete_UK]

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