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