SUMIFS using dates

Hi All,

I am hoping any kind person will be able to help as I cannot find the right SUMIFS formula to return the result I need. I am looking to produce a report that will return the name of a person staying in a room between 2 dates. I have attached an example file of data.

I am wanting to be able to change the date in cell F19, and the information be populated acordingly below.

I have been working on this all day, and I have been unable to work out the correct formula.

Thank you in advance to anyone willing to help!

Darren

Hi & welcome to the board.
How about

Formula:

Please Login or Register  to view this content.

WOW, thank you so much for your fast response. I have tried this on my sample formula and it works great. I now need to adapt this to my main file and hope I manage to do correctly.
Thank you again!

You're welcome & thanks for the feedback