LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!]

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting amounts in columns by due dates Anna Wood Excel Worksheet Functions 9 March 1st 10 02:51 PM
Finding amounts that meet specific criteria Brian Excel Discussion (Misc queries) 3 January 7th 09 10:42 PM
total amounts acquired through formula's referencing other sheet PVUMIGQS Excel Worksheet Functions 2 January 6th 08 12:20 PM
Want to total the amounts between certain dates KPyle Excel Discussion (Misc queries) 2 February 13th 07 09:18 PM
Dates/Amounts calcs KJo Excel Worksheet Functions 4 May 6th 05 06:40 PM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"