View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stinky Stinky is offline
external usenet poster
 
Posts: 10
Default 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!]