-
Re: How to use 'countif' with 'contains'
Hi Jef Snyders, I have created the formula to count the elements row-wise. Yes, you need to create a column where you will apply the formula. Alternatively, if you prefer to calculate within a single…1 · -
Re: Issues in using IF & AND formula in counting room nights
Hi Estela, As per my understanding, you want to know how many rooms are booked for particular dates. First create 2 columns to for your check in and check out dates, now you can use this formula to c…1 ·