I have dates of transactions in Column A,
the dates are not consecutive since some dates did not have transactions,
amounts are listed in column B.

How do i add up the amounts based on dates.
Cell C1 would be the 'from date' and D1 would be the 'to date'
E1 would contain the answer.