Spreadsheet: 755619d1636995778-countif-or-sumif-sumif-forum
Sheet: Sheet1

Patient | Status | CPT | Proc Name | Qty | [NAME] | Price | COST | EXPECTED |  |  |  | HB Chargecode | Description | Revenue Code | CPT Code | HB Price | PB Price
BLANK | Deleted | 0 | PR OFFICE/OUTPT VISIT,PROCEDURE ONLY | 1 | 11/03/2021 |  |  | 371.56 |  |  |  | 76100003 | HC I_D ABSCESS_ SIMPLE OR SINGLE | 761 | 10060 | 236.25 | 187.46
BLANK | Filed | 11042 | PR DEBRIDEMENT, SKIN, SUB-Q TISSUE=<20 SQ CM | 1 | 11/03/2021 |  |  | 371.56 |  |  |  | 76100055 | HC INCISION AND DRAINAGE HEMATOME_ SEROMA_FLUID COLLECTION | 761 | 10140 | 4084.57 | 260.28
BLANK | Filed | 11042 | HC DEBRIDEMENT, SC TISSUE; 1ST 20 SQ CM/LESS | 1 | 11/03/2021 |  |  | 371.56 |  |  |  | 76100059 | HC DEBRIDEMENT_ SC TISSUE_ 1ST 20 SQ CM_LESS | 761 | 11042 | 997.2 | 185.78
BOB | Deleted | 0 | PR OFFICE/OUTPT VISIT,PROCEDURE ONLY | 1 | 11/03/2021 |  |  | 371.56 |  |  |  | 76100060 | HC DEBRIDEMENT_ MUSCLE_AND FASCIA_ 1ST 20 SQ CM_LESS | 761 | 11043 | 1502.05 | 365.89
BOB | Filed | 11042 | PR DEBRIDEMENT, SKIN, SUB-Q TISSUE=<20 SQ CM | 1 | 11/03/2021 |  |  | 371.56 |  |  |  | 76100061 | HC DEBRIDEMENT BONE_ 1ST 20 SQ CM_LESS | 761 | 11044 | 359.23 | 505.19
BOB | Filed | 11042 | HC DEBRIDEMENT, SC TISSUE; 1ST 20 SQ CM/LESS | 1 | 11/03/2021 |  |  | 371.56 |  |  |  | 76100062 | HC DEBRIDEMENT_ SC TISSUE_ EA ADD_L 20 SQ CM | 761 | 11045 | 498.6 | 65.47
BROWN | Deleted | 99214 | HC OFFICE/OUTPATIENT ESTABLISHED MOD MDM 30-39 MIN | 1 | 11/03/2021 |  |  | 715.56 |  |  |  | 76100063 | HC HC DEBRIDEMENT_ MUSCLE_AND FASCIA_ EA ADD_L 20 SQ CM | 761 | 11046 | 2048.55 | 117.79
BROWN | Filed | 11042 | PR DEBRIDEMENT, SKIN, SUB-Q TISSUE=<20 SQ CM | 1 | 11/03/2021 |  |  | 715.56 |  |  |  | 76100064 | HC DEBRIDEMENT_BONE INCL SUBQ TISS_MUSCLE__OR FASCIA_EA ADDL 20SQ CM_OR PART THEREOF | 761 | 11047 | 2042.29 | 199.31
BROWN | Filed | 11042 | HC DEBRIDEMENT, SC TISSUE; 1ST 20 SQ CM/LESS | 1 | 11/03/2021 |  |  | 715.56 |  |  |  | 76100065 | HC PARING_CUTTING BENIGN HYPERKERATOTIC LESION_ SINGLE LESION | 761 | 11055 | 204.75 | 91.9
BROWN | Filed | 99214 | PR OFFICE/OUTPATIENT ESTABLISHED MOD MDM 30-39 MIN | 1 | 11/03/2021 |  |  | 715.56 |  |  |  | 76100247 | HC TANGENTIAL BIOPSY SKIN SINGLE LESION | 761 | 11102 | 527.25 | 160.78
BRUN | Filed | 99213 | PR OFFICE/OUTPATIENT ESTABLISHED LOW MDM 20-29 MIN | 1 | 11/03/2021 |  |  | 116.57 |  |  |  | 76100243 | HC PUNCH BIOPSY SKIN SINGLE LESION | 761 | 11104 | 425.25 | 202.19
 |  |  |  |  |  |  |  |  |  |  |  | 76100245 | HC INCISIONAL BIOPSY SKIN SINGLE LESION | 761 | 11106 | 997.2 | 244.57
 |  |  |  |  |  |  |  |  |  |  |  | 76100316 | HC EXC B9 LESION [NAME] T_A_L 3.1_4.0 CM | 761 | 11404 | 4084.57 | 346.27
 |  |  |  |  |  |  |  |  |  |  |  | 51000072 | HC TRIMMING NONDYSTROPHIC NAILS_ ANY METHOD | 761 | 11719 | 168.27 | 22.16
 |  |  |  |  |  |  |  |  |  |  |  | 76100070 | HC DEBRIDEMENT OF NAILS_S_ BY ANY METHOD_S__ 1_5 | 761 | 11720 | 168.27 | 51.5
 |  |  |  |  |  |  |  |  |  |  |  | 76100071 | HC DEBRIDEMENT OF NAILS_S_ BY ANY METHOD_S__ 6 OR MORE | 761 | 11721 | 168.27 | 72.05
 |  |  |  |  |  |  |  |  |  |  |  | 76100118 | HC AVULSION OF NAIL PLATE_ PARTIAL OR [NAME]_ SIMPLE_ SINGLE | 761 | 11730 | 502.14 | 158.66
 |  |  |  |  |  |  |  |  |  |  |  | 76100236 | HC REPAIR INTERMEDIATE S_A_T_E 2.5 CM_ | 761 | 12031 | 965.7 | 376.31
 |  |  |  |  |  |  |  |  |  |  |  | 76100073 | HC APPLY SKIN SUBSTITUE GRAFT_TOTAL WOUND AREA UP TO 100 SQ CM_ 1ST 25  SQ CM_LESS | 761 | 15271 | 2485.35 | 224.82
 |  |  |  |  |  |  |  |  |  |  |  | 76100074 | HC APPLY SKIN SUBSTITUE GRAFT_TOTAL WOUND AREA UP TO 100 SQ CM_ EA ADD_L 25 SQ CM | 761 | 15272 | 1242.68 | 43.42
 |  |  |  |  |  |  |  |  |  |  |  | 76100077 | HC APPL SKIN GRAFT FACE_SCALP_EYELIDS_MOUTH_EARS_GENITAL _100SCM_ 1ST 25 [NAME] | 761 | 15275 | 2485.98 | 239.59
 |  |  |  |  |  |  |  |  |  |  |  | 76100045 | HC DRESSING_DEBRIDEMENT BURNS_ INITIAL_SUBSEQUENT_ SMALL _LESS THAN 5_ BODY AREA_ | 761 | 16020 | 527.25 | 129.98
 |  |  |  |  |  |  |  |  |  |  |  | 76100299 | HC DRS__DBRDMT PRTL_THKNS BURNS 1ST_SBSQ MEDIUM | 761 | 16025 | 463.19 | 235.75
 |  |  |  |  |  |  |  |  |  |  |  | 76100081 | HC CHEMICAL CAUTERIZATION OF GRANULATION TISSUE | 761 | 17250 | 527.25 | 125.63
 |  |  |  |  |  |  |  |  |  |  |  | 76100082 | HC APPLY RIGID TOTAL CONTACT LEG CAST | 761 | 29445 | 740.16 | 218.04
 |  |  |  |  |  |  |  |  |  |  |  | 76100083 | HC STRAPPING_ UNNA BOOT | 761 | 29580 | 419.08 | 84.58
 |  |  |  |  |  |  |  |  |  |  |  | 76100084 | HC APPLY MULTI PAYER COMPRESSION SYSTEM_ LEG INCLUDING ANKLE AND FOOT | 761 | 29581 | 421.72 | 140.29
 |  |  |  |  |  |  |  |  |  |  |  | 30100145 | HC GLUCOSE_ QUANTITATIVE_ BLOOD | 301 | 82947 | 16.04 | 6.1
 |  |  |  |  |  |  |  |  |  |  |  | 30100652 | HC GLUCOSE BLOOD TEST | 301 | 82962 | 21 | 3.64
 |  |  |  |  |  |  |  |  |  |  |  | 77100001 | HC IMMUNIZATION ADMINISTRATION_ 1 [NAME] | 771 | 90471 | 86.27 | 39.98
 |  |  |  |  |  |  |  |  |  |  |  | 63600142 | HC TDAP FOR 7 YRS AND OLDER FOR IM USE | 636 | 90715 | 137.26 | 54.28
 |  |  |  |  |  |  |  |  |  |  |  | 92100018 | HC LIMITED BILATERAL NON INVASIVE VASCULAR STUDY_ 1_2 LEVELS | 921 | 93922 | 298.08 | 155.6
 |  |  |  |  |  |  |  |  |  |  |  | 92100031 | HC COMPLETE BILATERAL NON INVASIVE VASCULAR STUDY_ 3 OR MORE LEVELS | 921 | 93923 | 201.6 | 242.45
 |  |  |  |  |  |  |  |  |  |  |  | 92100038 | HC COMPLETE BILATERAL NONINVASIVE PHYSIOLOGIC STUDIES UPPER_LOWER EXTREMITY ARTERIES_3_MORE LEV | 921 | 93923 | 420.75 | 242.45
 |  |  |  |  |  |  |  |  |  |  |  | 76100087 | HC DEBRIDEMENT DEBRIS AND SKIN OPEN WOUND_ FIRST 20 SQ CM OR LESS | 761 | 97597 | 534.15 | 119.52
 |  |  |  |  |  |  |  |  |  |  |  | 76100088 | HC DEBRIDEMENT DEBRIS AND SKIN OPEN WOUND_ EA ADD_L 20 SQ CM_ OR PART THEREOF | 761 | 97598 | 266.7 | 54.23
 |  |  |  |  |  |  |  |  |  |  |  | 76100089 | HC NON SELECTIVE DEBRIDEMENT_ REMOVE DEV TISSUE_ WO ANESTHESIA | 761 | 97602 | 527.25 | 53.94
 |  |  |  |  |  |  |  |  |  |  |  | 76100090 | HC NEGATIVE PRESSURE WOUND THERAPY_ USING DME PER SESSION_ SURFACE  AREA LESS THAN__ TO 50 SQ CM | 761 | 97605 | 534.15 | 66.18
 |  |  |  |  |  |  |  |  |  |  |  | 76100091 | HC NEGATIVE PRESSURE WOUND THERAPY_ USING DME PER SESSION_ SURFACE AREA GREATER THAN 50 SQ C | 761 | 97606 | 980.75 | 78.04
 |  |  |  |  |  |  |  |  |  |  |  | 76100093 | HC OFFICE VISIT_ NEW PATIENT_ LOW TO MODERATE SEVERITY | 761 | 99202 | 347.42 | 119.11
 |  |  |  |  |  |  |  |  |  |  |  | 76100094 | HC OFFICE VISIT_ OP_ E_M_ NEW PT_ MODERATE_ 30 MINUTES | 761 | 99203 | 402.39 | 172.3
 |  |  |  |  |  |  |  |  |  |  |  | 76100095 | HC OFFICE VISIT_ OP_ E_M_ NEW PT_ HIGH_ 45 MINUTES | 761 | 99204 | 500.09 | 263.93
 |  |  |  |  |  |  |  |  |  |  |  | 76100097 | HC OFFICE VISIT_ ESTABLISHED PATIENT_ MINIMAL | 761 | 99211 | 222.76 | 31.67
 |  |  |  |  |  |  |  |  |  |  |  | 51000018 | HC OFFICE VISIT_ OP_ E_M_ ESTABLISHED PATIENT_ PROBLEMS LIMITED_MINOR_ 10 MIN FACE_TO_FACE | 510 | 99212 | 147.99 | 69.07
 |  |  |  |  |  |  |  |  |  |  |  | 76100098 | HC OUTPATIENT E_M_ ESTABLISHED PATIENT_ PROBLEMS LIMITED_MINOR_ 10 MIN FACE_TO_FACE | 761 | 99212 | 289.52 | 69.07
 |  |  |  |  |  |  |  |  |  |  |  | 51000019 | HC OFFICE VISIT_ OP_ E_M_ ESTABLISHED PATIENT_ LOW TO MODERATE_ 15 MIN FACE_TO_FACE | 510 | 99213 | 171.66 | 116.57
 |  |  |  |  |  |  |  |  |  |  |  | 76100099 | HC OUTPATIENT E_M_ ESTABLISHED PATIENT_ LOW TO MODERATE_ 15 MIN FACE_TO_FACE | 761 | 99213 | 335.33 | 116.57
 |  |  |  |  |  |  |  |  |  |  |  | 51000020 | HC OFFICE VISIT_ OP_ E_M_ ESTABLISHED PATIENT_ MODERATE TO HIGH_ 25 MIN FACE_TO_FACE | 510 | 99214 | 210.99 | 172
 |  |  |  |  |  |  |  |  |  |  |  | 76100100 | HC OUTPATIENT E_M_ ESTABLISHED PATIENT_ MODERATE TO HIGH_ 25 MIN FACE_TO_FACE | 761 | 99214 | 416.75 | 172
 |  |  |  |  |  |  |  |  |  |  |  | 76100101 | HC OUTPATIENT E_M_ ESTABLISHED PATIENT_ HIGH SEVERITY_ 40 MIN FACE_TO_FACE | 761 | 99215 | 549.87 | 231.91
 |  |  |  |  |  |  |  |  |  |  |  | 51000355 | HC PERIODIC PREVENTIVE E_M_ ESTABLISHED PATIENT_ AGE 40 THROUGH 64 YEARS | 510 | 99396 | 82.95 | 202.7
 |  |  |  |  |  |  |  |  |  |  |  | 51010247 | HC [NAME] TELEPHONE EVALUATION 5_10 MIN | 510 | 99441 | 147.99 | 69.07
 |  |  |  |  |  |  |  |  |  |  |  | 51010248 | HC [NAME] TELEPHONE EVALUATION 11_20 MIN | 510 | 99442 | 171.66 | 116.57
 |  |  |  |  |  |  |  |  |  |  |  | 41300002 | HC HYPERBARIC OXYGEN UNDER PRESSURE_ FULL BODY CHAMBER_ PER 30 MINUTES INTERVAL | 413 | G0277 | 360.36 | 127.06
 |  |  |  |  |  |  |  |  |  |  |  | 63600481 | HC THERASKIN 2.5 X 5.1_ PER SQ CM_ WOUND CARE | 636 | Q4121 | 483.79 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 63600483 | HC THERASKIN 7.6 X 15.2_ PER SQ CM_ WOUND CARE | 636 | Q4121 | 253.84 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 63600484 | HC THERASKIN 2.5 X 2.5_ PER SQ CM_ WOUND CARE | 636 | Q4121 | 483.79 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | 63600485 | HC THERASKIN 5.1 X 7.6_ PER SQ CM_ WOUND CARE | 636 | Q4121 | 101.46 | #N/A