Help with Index and Match Formula

[rizmomin]

Hello:

Please refer to attached file.
I have data as shown in column O thru Column EF
I need to summarize as shown in column D thru G for each Hotel listed in column B.
I beleive i got working formula for Hotel1.
Need to modify thiese formulas to down.

Let me know if you have any questions.
Thanks.

Riz

[Jacc]

Try this in D2:

Please Login or Register  to view this content.

Drag to the right and then down.

[rizmomin]

Hello Jacc

Thanks a lot

Riz

[jeffreybrown]

Riz,

You have way to many posts and time on this forum for a title such as this.

Please update your title to the forum rules.

[rizmomin]

Hello Jeffrey:

Thanks a lot

Riz

[jeffreybrown]

Thanks Riz