I have 3 Columns, B,C and D.

Columns B,C,D will be updated periodically and the number of rows will be increased day by day.

Columns B contains NAME, C contains Quantity and D has Date value.

```
Name Qt Date
SSS 20  
SSS 30  
NNN 50  
PPP 40  13-Jul-15
PPP 20  13-Jul-15
AAA 20  
CCC 100 
GGG 300 
FFF 200 
BBB 50  28-Aug-15
AAA 20  
GGG 100 
BBB 30  
JJJ 50  
BBB 30  
FFF 50  
FFF 25  24-Aug-15
CCC 75  
JJJ 30  
FFF 50  
JJJ 36  24-Aug-15
FFF 50  24-Aug-15

```

I need the result as below.

```
Name Qt
AAA 40
BBB 30
CCC 175
FFF 300
GGG 400
JJJ 80
NNN 50
SSS 50

```

Rows with date field(column D) having a value should be omitted from adding.

Name field can contain any name and future names can vary from current names.

The Result can be in the same sheet or in the different sheet.