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!
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!