yogi_Count Unique Values With Multiple Conditions

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

user lambchop said:
Hi, I am new to Google Docs and I'm trying to count unique entries for multiple conditions.  A simple example I have created is to count how many cities each employee is booked to visit and how many cities they actually attend.  Each city may only be counted once for each employee.  See example below,

EMPLOYEE  CITY         BOOKED VISITED

JAMES       SYDNEY           Y Y

JAMES       PERTH            Y N

JAMES       SYDNEY           Y Y

JAMES       BRISBANE         Y Y

SALLY       PERTH            Y Y

SALLY       PERTH            Y N

SALLY       DARWIN           Y Y

ROGER       CANBERRA         Y Y

ROGER       ADELAIDE         Y N

In this case, the results would be

EMPLOYEE BOOKED  ATTENDED

JAMES      3        2

SALLY      2        2

ROGER      2        1

I've created a test spreadsheet at the following link.  The results table above is located in sheet 2 named "RESULTS"

https://docs.google.com/spreadsheet/ccc?key=0AsiZG36EVbnAdHVuN1N6VTl4aXg5Qm81Z29zOTh2bHc&hl=en_GB#gid=0

I hope this is the right way to share this file.

-------------------------------------------------------

following is a solution to the problem