Sorting by date in excel 2000

[Guest]

Hi
I want to take a list of numbers (dollar amts.) that are not necessarily in chronological order, and total them by date. For example:
7/1/04 $5
7/1/04 $4
7/3/04 $2
7/2/04 $1
7/5/04 $4

Would give you
7/1/04 $9
7/2/04 $1
7/3/04 $2
7/4/04 $0
7/5/05 $4

Any help would be GREATLY appreciated.
Thanks

 

[Nick Hodge]

Simply you could use the SUMIF function like so

=SUMIF($A$1:$A$5,A1,$B$1:$B$5)

This will give duplicate 'totals' so if you wish to avoid this you could
used advanced filter to get a unique list somewhere on the sheet.
(Data>Filter>Advanced filter...)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

Hi
I want to take a list of numbers (dollar amts.) that are not necessarily

in chronological order, and total them by date. For example:

 

[Dave Peterson]

You may want to take a look at Data|Pivottable.

The data doesn't have to be sorted and once you invest a little bit of time,
you'll see how easy it is to do things like this:

If you want to learn more about pivottables, here are a few links.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[Guest]

Thank you very much. Worked like a dream.
-c

Simply you could use the SUMIF function like so

=SUMIF($A$1:$A$5,A1,$B$1:$B$5)

This will give duplicate 'totals' so if you wish to avoid this you could
used advanced filter to get a unique list somewhere on the sheet.
(Data>Filter>Advanced filter...)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)



in chronological order, and total them by date. For example: