"bobby769" wrote:
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.

One way:

=sumproduct((C1<=A1:A100)*(A1:A100<=D1),B1:B100)