How do I add amounts referencing specific dates?
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!]
|