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