date counting

[DrFreeze]

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?

 

[Bob Phillips]

Put the dates in column A of sheet 2, then use

B1: = SUMIF(Sheet1!A:A;A1;Sheet1!B:B)

you will need to change SUMIF to your language equivalent

--

HTH

RP
(remove nothere from the email address if mailing direct)