Formulae Required
Hi Team,
Require help in creating a formulae. I have data in two Columns: A1 - A10 (Room No) (101, 102, 103, 104) B1 - B10 (Booking Source) (Online, Walkin, FIT) What I require is to track how many times Room No 101 is booked which r marked as Online. Pls do help. Best Regards Akash Maheshwari |
Formulae Required
I have data in two Columns:
A1 - A10 (Room No) (101, 102, 103, 104) B1 - B10 (Booking Source) (Online, Walkin, FIT) What I require is to track how many times Room No 101 is booked which r marked as Online. Hopefully, this helps get started: =SUMPRODUCT(((A1:A10)=101)*((B1:B10)="Online")) |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com