How Can I Change Repeating date to one in excel? -

i have below question: on column a1: a16, have repeated dates. on column b1:b16, have numbers assigned each 1 date on column a. instance, b1 a1, b2 a2 , etc. copy column column c , use data – remove duplicates. now, want have total sum of numbers assigned each exact date on column d (front of column c). have attached example of excel sheet. how can do?

4/4/2015    20000000    4/4/2015    94010000 4/4/2015    9510000     4/9/2015     4/4/2015    50000000    4/13/2015    4/4/2015    14500000    4/14/2015    4/9/2015    200000000   4/19/2015    4/9/2015    200000000   4/27/2015    4/13/2015   672716000        4/14/2015   28448000         4/19/2015   26168000         4/19/2015   26168000         4/19/2015   18568000         4/19/2015   18568000         4/27/2015   41368000         4/27/2015   13500000         4/27/2015   200000000        4/27/2015   52926000     

extract unique items , corresponding totals

assuming data located follows:

dates range b7:b21 , amounts range c7:c21

to extract list of unique dates enter formulaarray in e7 , copy till last record:

(formulas array entered pressing [ctrl] + [shift] + [enter] simultaneously)

=iferror( index( $b$7:$b$21, match( 0, countif( $e$6:$e6, $b$7:$b$21 ), 0 ) * 1 ), "" ) 

then have total amount each date in next column enter formula in f7 , copy till last record:

=if( exact( $e7, "" ), "", sumif( $b$7:$b$21, $e7, $c$7:$c$21 ))