sum TOTAL with criteria

[tomhovens]

Hi All,

I'm looking for a formula to calculate the total amount of the contract. The input data is as follows:

- Contract: (Dimension)

- Date; (Dimension)

- Amount: sum(Amount)

- Total Amount: ???

Contract	Date	Amount	Total Amount
X	1/1/2016	15.000	30.000
X	5/1/2016	10.000	30.000
X	6/1/2016	5.000	30.000
Y	2/1/2016	25.000	45.000
Y	4/1/2016	20.000	45.000
Z	1/1/2016	35.000	35.000

[swuehl · Accepted solution]

=Sum(TOTAL<Contract> Amount)