I desire to combine values based on date, and then multiply those values by another tables date value

Hello all, hoping this is less punishing than stack exchange.

I am trying to determine cost basis for bitcoin. I have a spreadsheet of what was mined and when. I then also have a table of the daily value of bitcoin. I am seeking to determine a credible basis value. Its about 10k entries, several portions of blocks were mined daily. An example is 12/9/2017, I had three transactions. I would like to sum those amounts into one figure amd multiply it by the value that day. Alternatively, I could multiply the individual entries by that day, amd the sum them at the end. I am one of these people who thought they knew excel, only to realize I was not understanding just how much stuff it can do. If anyone can point me in the right direction I would appreciate it.