Page 2 of 2 FirstFirst 1 2
Results 11 to 15 of 15

Thread: Create Formula For Rooming List

  1. #11


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

    Quote Originally Posted by NBVC View Post
    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. #12
    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. #13
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    I would like you to update the sample with some relevant data, and show expected results.


  4. #14
    Quote Originally Posted by NBVC View Post
    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. #15
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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 FirstFirst 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
  •