Hi,

Let's say we have Column A containing dates in April 2010 and data to sum in
column B. Put this in a cell and it sums 1 April 2010. Drag down for 2 April
2010 etc

=SUMPRODUCT(($A$2:$A$100=DATE(2010,4,ROW(A1)))*($B $2:$B$100))


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Stinky" wrote:

If I have the following data:

Date No
07/04/2010 170
07/04/2010 175
08/04/2010 170
08/04/2010 170
08/04/2010 719
09/04/2010 1190
09/04/2010 340
12/04/2010 1020
12/04/2010 279


How do I sum up the no to give one value against each date, given that the
list of dates could be any date in the month?

[Hopefully my final post for this project and I have booked a training
session in 2 weeks to learn Pivot Tables!]