Hello,
I am getting crazy tryng to compare hotel prices between two given dates in
a large sheet.
I got some results with thousands of IF and Hlookup formulas.
Do you have any listing that I may adapt for this use to have a macro
calculating the amount column?

It looks like:
From Jun 20 to Sep 9
Date Jan1 Jun10 Aug30 Sep30 Dec31 Totals
HotelA FB ‚¬ 50,00 80,00 90,00 75,00 60,00 4900
HotelA BB ‚¬ 40,00 50,00 70,00 55,00 50,00 3200
Date
HotelB FB ‚¬ 00,00 70,00 90,00 70,00 00,00 4600
HotelB BB ‚¬ 00,00 00,00 00,00 00,00 00,00 0

Thank you for your help!
--
dilettante (=beginner)