Spreadsheet: 143574d1330464088-need-help-counting-adding-numbers-within-a-range-to-be-defined-example-for-forum
Sheet: Sheet1

Date | New Day | Pt Chart # | Case | Cases that Count | Procedure | Hosp Code    = 0 | Ins 1 | Ins 1 is M'd = 1 | Ins 2 | Ins 2 is M'd = 1 | Ins 3 | Ins 3 is M'd = 1 | Any Medicaid | Billing Code | Attending Provider | Office | Provider | Medicaid Patients
2011-01-03 00:00:00 |  | RICJA003 | 61059 |  | 99213 |  | TRI00 |  |  |  |  |  |  | CO | DWLYN
2011-01-03 00:00:00 |  | ANDSH001 | 61060 |  | 85610 |  | MED02 |  | CIG00 |  |  |  |  | MC | DWLYN
2011-01-03 00:00:00 |  | STONA000 | 61063 |  | 36415 |  | UNI01 |  |  |  |  |  |  | CO | DWLYN
2011-01-03 00:00:00 |  | VANDE000 | 61064 |  | 36415 |  | MED01 |  |  |  |  |  |  | MD | DWLYN
2011-01-03 00:00:00 |  | ALGJE000 | 61038 |  | 99213 |  |  |  |  |  |  |  |  | SP | JBLYN
2011-01-03 00:00:00 |  | ALGJE000 | 61038 |  | 36415 |  |  |  |  |  |  |  |  | SP | JBLYN
2011-01-03 00:00:00 |  | BOYWI000 | 61039 |  | 99213 |  |  |  |  |  |  |  |  | A | JBLYN
2011-01-03 00:00:00 |  | CALDI000 | 61040 |  | 99213 |  |  |  |  |  |  |  |  | A | JBLYN
2011-01-03 00:00:00 |  | CRODA002 | 61041 |  | 99214 |  | SAG08 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | CROWI000 | 61042 |  | 99213 |  | SAG08 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | FOULA000 | 61043 |  | 99213 |  | ENC00 |  | SAG08 |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | MCAJE000 | 61044 |  | 99213 |  | MED00 |  | MED01 |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | MCAJE001 | 61045 |  | 99213 |  | MED01 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | OWEPA000 | 61046 |  | 99213 |  | MED00 |  |  |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | WORRA000 | 61047 |  | 99213 |  | MED00 |  |  |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | BIEMA000 | 61048 |  | 99213 |  | GOL00 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | BIEEM000 | 61049 |  | 99213 |  | NPP00 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | ROGSA000 | 61050 |  | 99203 |  | MED05 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | WICOL000 | 61051 |  | 99213 |  | ANT00 |  |  |  |  |  |  | BC | JBLYN
2011-01-03 00:00:00 |  | WICOL000 | 61051 |  | 87880 |  | ANT00 |  |  |  |  |  |  | BC | JBLYN
2011-01-03 00:00:00 |  | BUFER000 | 61052 |  | 99213 |  | ANT00 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | CAMTI000 | 61053 |  | 99214 |  | MDW01 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | GRADO000 | 61054 |  | 99213 |  |  |  |  |  |  |  |  | A | JBLYN
2011-01-03 00:00:00 |  | [NAME] | 61055 |  | 99213 |  | MDW00 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | PATDA000 | 61058 |  | 99213 |  | UNI14 |  |  |  |  |  |  | A | JBLYN
2011-01-03 00:00:00 |  | GIRSH000 | 61061 |  | 36415 |  | MER00 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | ROTJA000 | 61065 |  | 82947 |  | ADV00 |  |  |  |  |  |  | CO | JBLYN
2011-01-03 00:00:00 |  | WISAN000 | 61067 |  | 99214 |  | MED00 |  | MUT00 |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | RICGA000 | 61068 |  | 99214 |  | MED00 |  | AAR02 |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | RICGA000 | 61069 |  | 81002 |  | MED00 |  | AAR02 |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | PETGR000 | 61070 |  | 99213 |  | ANT00 |  |  |  |  |  |  | BC | JBLYN
2011-01-03 00:00:00 |  | PETGR000 | 61070 |  | 85610 |  | ANT00 |  |  |  |  |  |  | BC | JBLYN
2011-01-03 00:00:00 |  | HARVI001 | 61071 |  | 99213 |  | MED00 |  | RUR00 |  |  |  |  | MC | JBLYN
2011-01-03 00:00:00 |  | WYSHO000 | 61072 |  | 99213 |  | MDW00 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | LUMPA000 | 61073 |  | 99213 |  | MDW00 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | LUMPA000 | 61073 |  | 87880 |  | MDW00 |  |  |  |  |  |  | MD | JBLYN
2011-01-03 00:00:00 |  | [NAME] | 61019 |  | 99214 |  |  |  |  |  |  |  |  | SP | DWNPR
2011-01-03 00:00:00 |  | HALNO000 | 61020 |  | 99214 |  | MED00 |  | MED01 |  |  |  |  | MC | DWNPR
2011-01-03 00:00:00 |  | LEWHE000 | 61021 |  | 99213 |  | MDW00 |  |  |  |  |  |  | MD | DWNPR
2011-01-03 00:00:00 |  | LEWVI000 | 61022 |  | 99214 |  | MDW00 |  |  |  |  |  |  | MD | DWNPR
2011-01-03 00:00:00 |  | COUKI000 | 61024 |  | 99213 |  | ANT00 |  |  |  |  |  |  | BC | DWNPR
2011-01-03 00:00:00 |  | COUKI000 | 61024 |  | 36415 |  | ANT00 |  |  |  |  |  |  | BC | DWNPR
2011-01-03 00:00:00 |  | POTME000 | 61025 |  | 99214 |  | MED00 |  | ANT00 |  |  |  |  | MC | DWNPR
2011-01-03 00:00:00 |  | POTME000 | 61026 |  | 90658 |  | MED00 |  | ANT00 |  |  |  |  | MC | DWNPR
2011-01-03 00:00:00 |  | MEAJA000 | 61028 |  | 99213 |  |  |  |  |  |  |  |  | SP | DWNPR
2011-01-03 00:00:00 |  | LEWCY000 | 61029 |  | 99214 |  | ANT00 |  | MED03 |  | MED |  |  | 04 MC | DWNPR
2011-01-03 00:00:00 |  | MITFL000 | 61030 |  | 99214 |  | MED00 |  | RUR00 |  |  |  |  | MC | DWNPR
2011-01-03 00:00:00 |  | FIEMA000 | 61031 |  | 36415 |  | MED01 |  |  |  |  |  |  | MD | DWNPR
2011-01-03 00:00:00 |  | FIDMA000 | 61032 |  | 99214 |  | SAG15 |  |  |  |  |  |  | CO | DWNPR
2011-01-03 00:00:00 |  | FIDMA000 | 61032 |  | 87880 |  | SAG15 |  |  |  |  |  |  | CO | DWNPR
2011-01-03 00:00:00 |  | BRADO000 | 61033 |  | 99214 |  | MED00 |  |  |  |  |  |  | MC | DWNPR
2011-01-03 00:00:00 |  | BRAFR001 | 61034 |  | 99214 |  | HUMAN |  | ANT00 |  |  |  |  | CO | DWNPR
2011-01-03 00:00:00 |  | BARLE000 | 61035 |  | 99214 |  | ANT00 |  |  |  |  |  |  | BC | DWNPR
2011-01-03 00:00:00 |  | HOLDU000 | 61036 |  | 99214 |  | MDW00 |  |  |  |  |  |  | MD | DWNPR
2011-01-03 00:00:00 |  | SMILA001 | 61037 |  | 90471 |  | MER00 |  |  |  |  |  |  | CO | DWNPR
2011-01-03 00:00:00 |  | SMILA001 | 61037 |  | 90658 |  | MER00 |  |  |  |  |  |  | CO | DWNPR
2011-01-03 00:00:00 |  | VANJA001 | 61023 |  | 99214 |  |  |  |  |  |  |  |  | SP | DWRID
2011-01-03 00:00:00 |  | POTME000 | 61027 |  | 36415 |  | MED00 |  | ANT00 |  |  |  |  | MC | DWRID
2011-01-04 00:00:00 |  | GRETH000 | 61102 |  | 99213 |  | MED00 |  | AAR01 |  |  |  |  | MC | DWLYN
2011-01-04 00:00:00 |  | COXJU000 | 61119 |  | 99213 |  | GRE00 |  |  |  |  |  |  | CO | DWLYN
2011-01-04 00:00:00 |  | COXWE000 | 61120 |  | 99213 |  | GRE00 |  |  |  |  |  |  | CO | DWLYN
2011-01-04 00:00:00 |  | AUKLI000 | 61770 |  | 99307 |  | MED01 |  |  |  |  |  |  | MD | DWLYN
2011-01-04 00:00:00 |  | LEESA000 | 61114 |  | 90471 |  | MDW00 |  |  |  |  |  |  | MD | DWNPL
2011-01-04 00:00:00 |  | LEESA000 | 61114 |  | 90658 |  | MDW00 |  |  |  |  |  |  | MD | DWNPL
2011-01-04 00:00:00 |  | RINJE000 | 61115 |  | 85610 |  |  |  |  |  |  |  |  | SP | DWNPL
2011-01-04 00:00:00 |  | BLAGL000 | 61101 |  | 99213 |  | TOM00 |  |  |  |  |  |  | WC | JBLYN
2011-01-04 00:00:00 |  | HEDPH000 | 61103 |  | 99214 |  | SEC00 |  |  |  |  |  |  | MC | JBLYN
2011-01-04 00:00:00 |  | LEEMO000 | 61104 |  | 99213 |  |  |  |  |  |  |  |  | A | JBLYN