View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default 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"))