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

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