Trying to Add Up Amount Between Date Ranges

[ohanish]

Hello Excel Guru's,

I really need some help with the attached file.

On the file in the table labeled Dashboard I have created two drop down's. The first is the start date and the second is the end date. I want to fill in the tabs for the number of travelers and the amount collected as the dates change. The information needed is on the right of the table which is all the days of the year. I am hoping someone can help me, I have a lot riding on this. Thank You in advance. Excel_Selection.xlsx

[cbatrody]

Hi,

Please use the following formula in E2:

=SUMIFS($J$2:$J$357,$H$2:$H$357,">="&B2,$H$2:$H$357,"<="&$D$2)

F2:
=SUMIFS($I$2:$I$357,$H$2:$H$357,">="&B2,$H$2:$H$357,"<="&$D$2)

[lts_ram]

Hello,
welcome
in e2=sumif((h3:h356),indirect("b2"),(j3:j356))
in f2 =sumif((h3:h356),indirect("b2"),(i3:i356))

[cbatrody]

Alternatively,

E2:
=SUMPRODUCT(--($H$2:$H$357>=$B$2),--($H$2:$H$357<=$D$2),($J$2:$J$357))

F2:
=SUMPRODUCT(--($H$2:$H$357>=$B$2),--($H$2:$H$357<=$D$2),($I$2:$I$357))