SUMPRODUCT function?

Good afternoon from rainy Brussels!

I need your help regarding the attached document:

sample file.xlsx

In columns A and B, I have respectively the arrival and departure dates of hotel guests.

In column I, I have the average room rate and in column K, I have the number of room nights produced.

Now in column L, I would like to know exactly how much money the reservations that I have in columns A and B have produced. (in total)

For example, for the 21st of May, the result should be 100.82. For the 24th of May, it should be 283.36 (100.82+182.54)

Can anyone help me?

Thanks a lot!!

Adrien

Originally Posted by JBeaucaire

In L2, then copied down:

=SUMIFS(I:I, A:A, "<="&J2, B:B, ">="&J2)

Thanks a lot Jerry!!!