# Thread: Create Formula For Rooming List

1. Register for a FREE account, and/
or Log in to avoid these ads!

Originally Posted by NBVC
I might have added the wrong attachment. Here is the right one....

also, if canard2 does require the 4 day min no matter the days stayed in that date range, then the P3 formula would become:

=IFERROR(VLOOKUP(G33,\$U\$2:\$V\$4,2,0)*MAX(4,SUM(\$I33:\$N33))+24.2,"")

copied down.
Great. This helps. Thanks.

2. HelloI have another request. For the same spreadsheet.
I have different hotels. What formula can I use to see how many rooms I have left for my rooming list?

Cheers

3. I would like you to update the sample with some relevant data, and show expected results.

4. Originally Posted by NBVC
I would like you to update the sample with some relevant data, and show expected results.
Hi I found the solution using SUMIFS. This is the solution I used (in words) = =Roomblock-(SUMIFS(Column P(which is my 1st night),Column O (attributed hotel, Name of hotel) and it worked.

I wanted to just write the name of hotel but was unable to create the formula when the hotel had 2 words. Does the formula only accept one word (ex; =\$AF\$2-(SUMIFS(S\$3:S\$66,\$O\$3:\$O\$66,"catalonia")) -> this works but it I do =\$AF\$2-(SUMIFS(S\$3:S\$66,\$O\$3:\$O\$66,"Hilton NYC")) It does not work (I tried underscore, no space etc)

5. That should work as long as there is an exact match. Make sure that your "match" in column O doesn't have extra space at the end or in between words.

Page 2 of 2 First 1 2

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•