How to sum a column base on a few unique criterias

[greatutopia]

I would like to sum the amount column of unique date that is in active status of each account. Anyone can help? Thanks.

Account Date Status Amount
11 jan 1 A 200
12 jan 1 A 5
13 jan 1 A 1000
11 jan 1 A 200
11 jan 3 A 100
12 jan 3 A 8
13 jan 4 A 1
13 jan 4 A 1
11 jan 6 I 50
12 jan 6 A 10

Below is the expected result
Account Amount
11 300 (200+100)
12 23 (5+8+10)
13 1001(1000+1)

[BadlySpelledBuoy]

Are you sure about your expected resutls?

Why is 11 not 500 (200+200+100)?
And 13 not 1002 (1001+1+1)?

[greatutopia]

As I only want the amount of unique date, so it only need to add 200( jan 1 of 11) once. same case for 13.