Spreadsheet: 860690d1708695958-of-true-and-false-excluding-blank-cells-how-do-i-count-true-and-false-but-ignore-cells-that-have-an-embedded-forula-that-returns-a-blan
Sheet: Sheet1

 | RAW DATA |  |  |  |  |  |  | TRUE/FALSE LOGIC FOR MATCHES - RETURNS BLANK WHEN DOES NOT MEET INCLUSION CRITERIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COUNT OF TRUE FALSE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMMARY IN % AND TOTAL COUNT OF TRUE/FALSE
Facility | Disch Disp | PT D/C Recommendations | OT D/C Recommendations | PT DARRT | OT DARRT | OT-PT Tool Time |  | [NAME], PT D/C AND OT D/C Match | [NAME] and PT Match | [NAME] and OT Match | PT and OT Match when OT-PT tool time is <48hrs | PT and OT Match when OT-PT tool time is <24hrs | PT D/C and PT DARRT Match | OT D/C and OT DARRT Match | [NAME] and PT DARRT Match | [NAME] and OT DARRT Match | [NAME] and OT DARRT Match AND OT D/C Nonmatch | [NAME] and PT DARRT Match AND PT D/C Nonmatch | All 5 agree when OT-PT tool time is <48hrs | All 5 agree when OT-PT tool time is <24hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <48hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <24hrs |  | [NAME], PT D/C AND OT D/C Match | [NAME] and PT Match | [NAME] and OT Match | PT and OT Match when OT-PT tool time is <48hrs | PT and OT Match when OT-PT tool time is <24hrs | PT D/C and PT DARRT Match | OT D/C and OT DARRT Match | [NAME] and PT DARRT Match | [NAME] and OT DARRT Match | [NAME] and OT DARRT Match AND OT D/C Nonmatch | [NAME] and PT DARRT Match AND PT D/C Nonmatch | All 5 agree when OT-PT tool time is <48hrs | All 5 agree when OT-PT tool time is <24hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <48hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <24hrs |  | [NAME], PT D/C AND OT D/C Match | [NAME] and PT Match | [NAME] and OT Match | PT and OT Match when OT-PT tool time is <48hrs | PT and OT Match when OT-PT tool time is <24hrs | PT D/C and PT DARRT Match | OT D/C and OT DARRT Match | [NAME] and PT DARRT Match | [NAME] and OT DARRT Match | [NAME] and OT DARRT Match AND OT D/C Nonmatch | [NAME] and PT DARRT Match AND PT D/C Nonmatch | All 5 agree when OT-PT tool time is <48hrs | All 5 agree when OT-PT tool time is <24hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <48hrs | PT DARRT and OT DARRT Match when OT-PT tool time is <24hrs
 | Home | Home | Home | Home | Home | 28.14097222220153
 | Home | Home | Home | Home | Home | 22.11111111110222
 | Home | Home | Home | Home | Home | 22.08611111110076
 | Home | Home | Home | Home | Home | 16.08819444439723
 | Home | Home | Home | IRF | IRF | 15.79166666670062
 | Home | Home | Home | SNF | SNF | 15.08333333340124
 | Home | Home | Home | Home | Home | 15.03194444449764
 | Home | Home | Home | Home | Home | 14.96944444449764
 | Home | Home | Home | Home | SNF | 14.96250000000146
 | Home | Home | Home | Home | Home | 14.95486111110222
 | Home | Home | Home | Home | Home | 14.20833333329938
 | Home | Home | Home | Home | Home | 14.11111111110222
 | Home | Home | Home | Home | Home | 13.27083333329938
 | Home | Home | Home | Home | Home | 13.125
 | Home | Home | Home | Home | SNF | 13.06597222229902
 | Home | Home | Home | Home | Home | 12.875
 | Home | Home | Home | Home | Home | 12.83958333329792
 | Home | SNF | SNF | SNF | SNF | 12.08333333340124
 | Home | Home | Home | Home | Home | 11.97777777779993