Hi
What do you mean by "compare"?
What do you mean by "calculate the amount column"?

Assuming the data you have given is the input, what do you want as an
output?
regards
Paul

dilettante wrote:
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)