excel - combine dates into 1 and combine other cells (amounts) into 1 cell in Google Sheets -

i have question use google sheets , data api sheets uploads orders date of order , amount of order.

now if 10 orders 10 rows of (21-7-2015) , amount

i want automated process combines these order dates , amounts if 10 orders 1 euro on 27-7-2015 should have 1 row of 21-7-2015 in a1 date colum , g5 ( in case should have total amount of 10) 10x 1 euro combined

now trick . not sure if getting 5 orders per day or 10 should combine if dates same

i hope can make myself clear do. please see layout here

https://docs.google.com/spreadsheets/d/1cj6fjrzt9tmykkk41crsza4cl8dbhoiepi52rejzk8s/edit?usp=sharing

its (colum colum g)

it looks you've made list of unique dates in column , want automatically fill in column j. can use sumif. j3 be.

=sumif(a:a, i3, b:b)

this says, of rows in column contain value in j:3. add corresponding values column b.