Last seen: Aug 30, 2025
Hello Mitul, I suggest you check the spelling in cell E5. You have typed in ”Excel” Pamphlets but in your data range you don’t have that text, you ...
Hi Lea, As you probably noticed, I was not sure how you wanted to count based on CheckOut date, so I gave two different options. Just glad I could ...
Hello Mitul, The formula should read =SUMPRODUCT(C6:C36*(B6:B36=E4)+C6:C36*(B6:B36=E5)) And you need to check the data entered, below picture...
Hello Lea, You need to use array formulas to sum / count the number of guests and rooms. See attached file for reference. To be able to use same...
Yep, I can only agree. The articles in this blog was what caught my attention first, I have learned a lot from them. Then I took some courses and they...
Hello Ryan, Yes, when you get a matrix like the example you share, then you are better off using INDEX and MATCH. Based on your file, the formul...
Hello Mitul, It depends on how you type it in. If you for example type the dates as Jan. -15, Feb. -15, Mar. -15 etc, then no, Excel will not de...
Hello Samantha, I am just glad I could be of help. Have a great evening now. /Anders
Hello Ryan, Just wondering if the tip in this VLOOKUP article can give you some way forward in creating such calculator. Br, Anders
Hello Samantha, It is not a difficult question, but how well things works depends on which version of Excel you are running. Best option would of c...
Hello Ali, I am sorry, I don't understand what you want to do. If you can provide a sample file that would be much better. Br, Anders
Hello Mitul, You're striving on, good to see. Let's see if I can answer your questions. Q1) Flash fill works fine, if it senses there is a patte...
Hello Vladimir, There are some tips for you at this site to check and see if it helps you. Good luck. Br, Anders
Hello Azri, Thank you for your feedback, always nice to know that a problem was solved. Yes, you can just add the extra sheets in the first sect...
Hello Azri, As per your setup I would use an array formula to sum the different criterias from the different sheets. In your Summary sheet, paste i...