Yikes!!
=Sumproduct(($A$1:$A$7=D1)-($B$1:$B$7))
should be:
=Sumproduct(($A$1:$A$7=D1)*($B$1:$B$7))

"Jim May" wrote in message
news:okTEe.82055$Fv.57592@lakeread01...
With your given data in A1:B7, click in Cell D1
then at the menu Data, Filter, Advanced-Filter,
List range s/b = $A$1:$A$7; Criteria range - leave blank;
click Copy to another range, then in Copy to: enter D1,
finally click on the Unique records Only box.; OK
D1:D4 << should be your unique dates;
In Cell E1 enter: =Sumproduct(($A$1:$A$7=D1)-($B$1:$B$7))
Copy E1 down to E4
HTH;


"Nobody I via OfficeKB.com" wrote in message
...

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