Dynamic Table based on Date Range

[bujaman]

I have a table of financial data. The data is organized with a transaction date in column A, expense category in B, and amount in C. I would like to organize the data in a separate table that shows only the category and total amount associated with that category, and allow the user to input two dates, a start and end, and the table will update and show only data that falls within that range. Is this possible? I have been playing around with pivot tables, but have not gotten the results that I am looking for. Any help is appreciated, thanks!