Sum a range of cell in a column based on the the two cells from another column

[HI808]

Hi everyone,

On the spread sheet, I have two columns, column A is for Date, column B is for Revenue. I want to sum the revenue based on any specific date range on column A. For example, i want to know how much is the revenue from 4/15 to 4/30 or 4/1 to 4/20. The start date (4/15) and the end date (4/30) will be manual input from a specific cell (start date on cell D1, and end date on cell E1) and the sum of the revenue will be on cell F1. So any time I change the date on cell D1 and E1, i will get the sum revenue on cell F1.

Thank you so much for help.

[Phuocam]

Try this...
=SUMIFS(B:B,A:A,">="&D1,A:A,"<="&E1)

[HI808]

Thank you so much Phuocam for your quick reply and your formula works perfectly. Thank you

[Phuocam]

You're welcome!