Google Sheets Count Unique with Multiple Criteria

[jemrisin]

For this Google spreadsheet I would like to do the following:

Count the Unique "Provider User IDs" (column C) that meet the following criteria:


a) Column H = "Incomplete" OR "Provider Missed"
b) Column K = 3/24/14 < Value <= 4/30/14
c) Column X = "School 1"


I believe I know how to do this for standard excel but I'm having trouble getting it to return what I expect for Google Sheets.


Any help would be greatly appreciated!