hi there,

I need a solution for excel.

Sheet1. This worksheet excists of a column DATE where a user can fill in
dates. These dates are of the format: dd/mm/yyyy .
And a column AMOUNT. Where a user can fill in an amount.
This amount is of the format: number, decimal 2

for example:

05/07/2005 | 15,30
12/07/2005 | 34,80
12/07/2005 | 8,50
12/07/2005 | 12,90
20/07/2005 | 5,00
20/07/2005 | 7,50
24/07/2005 | 100,60

What I want to accomplish is the following.

Excel has to make a SOM from the amounts per date. and list these SOMs on
sheet2.

in the format:

05/07/2005 | 15,30
12/07/2005 | 56,20
20/07/2005 | 12,50
24/07/2005 | 100,60


Can excel do this?
Edit/Delete Message