Spreadsheet: 43252d1241815539-sum-a-column-a-if-column-b-contains-1-of-multiple-possible-criteria-example-excel-help
Sheet: 08cy

discharged | LOS SOC-EOC | D/C -DEATH | D/C- revoke/refused | D/C- no qual | D/C cause(c) or moved(m) | Place  death | LOS w/in FY only | NAME | admit | D/C | days at | PCP | admit CY | Admit prev CY | d/c CY | Carry into nxtyr | referral | 1st admit
1 | 360 | 0 | 0 | 1 |  | 0 | 25 |  | 2007-01-31 00:00:00 | 2008-01-25 00:00:00 | ltc | Cahill |  | 1 | 1 |  | pcp | 1
1 | 90 | 0 | 0 | 1 |  | 0 | 72 |  | 2007-12-14 00:00:00 | 2008-03-12 00:00:00 |  | [NAME] |  | 1 | 0 |  | pcp | 1
1 | 6 | 1 | 0 | 0 |  | 3 | 6 |  | 2008-03-17 00:00:00 | 2008-03-22 00:00:00 | gip | Clarke | 1 |  | 1 |  | pcp | 1
1 | 240 | 0 | 0 | 1 |  | 0 | 240 |  | 2008-03-28 00:00:00 | 2008-11-22 00:00:00 |  | cahill | 1 |  | 1 |  | pcp | 1
1 | 122 | 1 | 0 | 0 |  | 4 | 122 |  | 2008-05-14 00:00:00 | 2008-09-12 00:00:00 | alf | [NAME] | 1 |  | 1 |  | family | 1
1 | 6 | 1 | 0 | 0 |  | 1 | 6 |  | 2008-05-17 00:00:00 | 2008-05-22 00:00:00 |  | TAG | 1 |  | 1 |  | family | 1
1 | 3 | 1 | 0 | 0 |  | 2 | 3 |  | 2008-05-12 00:00:00 | 2008-05-14 00:00:00 | ltc | [NAME] | 1 |  | 1 |  | swing | 1
1 | 1 | 1 | 0 | 0 |  | 1 | 1 |  | 2008-05-30 00:00:00 | 2008-05-30 00:00:00 | h | TAG | 1 |  | 1 |  | hh | 1
1 | 156 | 1 | 0 | 0 |  | 1 | 156 |  | 2008-06-02 00:00:00 | 2008-11-04 00:00:00 |  | hussey | 1 |  | 1 |  | pcp | 1
1 | 14 | 1 | 0 | 0 |  | 1 | 14 |  | 2008-08-05 00:00:00 | 2008-08-18 00:00:00 |  | [NAME] | 1 |  | 1 |  | pcp | 1
1 | 15 | 1 | 0 | 0 |  | 1 | 15 |  | 2008-08-06 00:00:00 | 2008-08-20 00:00:00 |  | hussey | 1 |  | 1 |  | pcp | 1
1 | 46 | 1 | 0 | 0 |  | 2 | 46 |  | 2008-09-09 00:00:00 | 2008-10-24 00:00:00 | 5res/25LTC /16home | hussey | 1 |  | 1 |  | pcp | 1
1 | 13 | 1 | 0 | 0 |  | 2 | 13 |  | 2008-09-10 00:00:00 | 2008-09-22 00:00:00 | transf on  9/18/08 to us | hussey | 1 |  | 1 |  | transfer | 1
1 | 39 | 1 | 0 | 0 |  | 1 | 39 |  | 2008-09-24 00:00:00 | 2008-11-01 00:00:00 |  |  | 1 |  | 1 |  | pcp | 1
1 | 44 | 0 | 0 | 0 | 1 | 0 | 44 |  | 2008-10-29 00:00:00 | 2008-12-11 00:00:00 |  | rwb | 1 |  | 1 |  | [NAME] | 1
0 |  | 0 | 0 | 0 |  | 4 | 2 |  | 2008-12-30 00:00:00 |  | afh | hussey | 1 |  | 0 | 1 | family | 1 | 1 | 0 | 1
 | 39 | 10 | 0 | 3 | 1 | median | 20 |  |  |  |  |  |  | 2 |  | 1 | 16
 | 77 |  |  |  |  | avg | 50.25
 | 38.27272727272727 |  |  | avg los deaths only |  |  | 38.27272727272727 | 804
 | 15 |  |  | Median los deaths
 |  | INSURANCE |  |  |  | totals |  | PLACE OF DEATH |  | Totals
 |  | 1.  Medicare payors (all) |  |  |  | #N/A | #N/A | 1.   Home |  | 0.5454545454545454 | 6 | Total pt days: |  |  | 804
 |  | 2.  Medicaid payors (all) |  |  |  | #N/A | #N/A | 2.   LTC |  | 0.2727272727272727 | 3 | Total new admits |  |  | 16
 |  | 3.  Private (all) |  |  |  | #N/A | #N/A | 3.   General inpatient/respite |  | 0.09090909090909091 | 1 | readmit from a current year |  |  | 0
 |  | 4.  Private Pay (all) |  |  |  | #N/A | #N/A | 4.   AFH |  | 0.09090909090909091 | 1 | readmit in this current yr |  |  | 0
 |  | 5.  Charity (all) |  |  |  | #N/A | #N/A |  |  |  |  | Total deaths |  |  | #N/A
 |  | 6.  Private policy (all) |  |  |  | #N/A | #N/A |  |  |  |  | total non death d/c |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | Hospice d/c'd |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | Referrals |  |  | #N/A
 | refer | RESON not taken on |  |  |  | Place death |  | NAME |  |  |  | alos for d/c |  |  | 76.07142857142857 | 76.07142857142857
 | [NAME] | died a admiti-courtestied in hosp |  |  |  | [NAME] |  | overton, bill |  |  |  | median LOS
 | fam | wklyparacentesis |  |  |  | [NAME] |  | [NAME] | family/friendreferral-ptdeferred |  |  | LOS 1-7 daus |  |  | 35 |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | LOS 8-14 days
 |  |  |  |  |  |  |  |  |  |  |  | LOS 15-29 days
 |  |  |  |  |  |  |  |  |  |  |  | Los  30-59
 |  |  |  |  |  |  |  |  |  |  |  | LOS 60-89
 |  |  |  |  | Cancer admissions |  |  | #N/A |  |  |  | LOS 90-179
 |  |  |  |  | cancer deaths |  |  |  |  |  |  | LOS 180+
 |  | LHH&H |  | OHA
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | #N/A
 |  | 0.06
 |  | 0.88
 |  | 0.06
 |  | 0
 |  | 0
 |  | 0.54
 |  | 0.09
 |  | 0
 |  | 0.09
 |  | 0.27
 |  | 0
 |  | 0
 |  | 0.6
 |  | 0.2
 |  | 0.2
 |  | 11
 |  | 1.6
 |  | 4.8
 |  | 0.2
 |  | 0
 |  | 0
 |  | 3
 |  | 0
 |  | 25.4
 |  | 0.6
 |  | 0.5
 |  | 0
 |  | 0
 |  | 26.5
 |  | 78.3
 |  | 6.45
 |  | 0.36
 |  | 0.04
 |  | 0.07
 |  | 0.1
 |  | 0
 |  | 0.1
 |  | 0.01
 |  | 0.1