Spreadsheet: 691607d1597775538-countif-or-sumif-2020-08-18-oeldere-ron-purpura-691605d1597774973-countif-or-sumif-rvu-total
Sheet: Sheet1

MRN | Service Dt | Prov # | Procedure | Work RVU | Total RVU for Serv Date
41091864 | 2020-07-28 00:00:00 | 12306 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37 | 1.37 |  | Hello All
41084970 | 2020-07-31 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42 | 1.42 |  | Looking for some help using ( what I think) should be a COUNTIF or SUMIF function , or anything that would work
41082899 | 2020-06-18 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42 | 1.42 |  | Attached is an example
41082429 | 2020-06-10 00:00:00 | 12554 | PR PREVENTIVE VISIT,NEW,INFANT < 1 YR [99381] | 1.5 | 1.5 |  | My goal is to add the values in Column E if Columns A , B and C match
41055784 | 2020-05-29 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42 | 1.42 |  | Basically if the Patient ID (Column A) came into the office ( Service date , Column B) and had several charges submitted by Provider ( Column C) to the Insurance company (Column E) for the same Service date( Column B) I would like to know the total charges submitted to the Ins Comp ( Column F) for that patient based on service date (Column B)
41055036 | 2020-05-21 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42 | 1.42
41054635 | 2020-07-20 00:00:00 | 10410 | PR PREVENTIVE VISIT,NEW,18-39 [99385] | 1.92 |  |  | Thanks in advance
41054635 | 2020-07-20 00:00:00 | 10410 | PR TDAP VACCINE >7 YO, IM [90715] | 0
41054635 | 2020-07-20 00:00:00 | 10410 | PR IMMUNIZ ADMIN,1 SINGLE/COMB VAC/TOXOID [90471] | 0.17
41053553 | 2020-05-11 00:00:00 | 10410 | PR PREVENTIVE VISIT,NEW,INFANT < 1 YR [99381] | 1.5 | 1.5
41053553 | 2020-06-04 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37 | 1.37
41053553 | 2020-07-06 00:00:00 | 12306 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97 | 0.97
41053553 | 2020-07-16 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41053553 | 2020-07-16 00:00:00 | 10410 | PR DTAP-HEPB-IPV VACCINE INTRAMUSCULAR [90723] | 0
41053553 | 2020-07-16 00:00:00 | 10410 | PR HIB PRP-OMP VACCINE 3 DOSE SCHEDULE IM USE [90647] | 0
41053553 | 2020-07-16 00:00:00 | 10410 | PR PCV13 VACCINE FOR INTRAMUSCULAR USE [90670] | 0
41053553 | 2020-07-16 00:00:00 | 10410 | PR RV5 VACCINE 3 DOSE SCHEDULE LIVE FOR ORAL USE [90680] | 0
41053553 | 2020-07-16 00:00:00 | 10410 | PR IMMUNIZ ADMIN, THRU AGE 18, ANY ROUTE,W COUNSEL, 1ST VACCINE/TOXOID [90460] | 0.17
41053553 | 2020-07-24 00:00:00 | 12306 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97 | 0.97
41053412 | 2020-05-08 00:00:00 | 40248 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37 | 1.37
41053412 | 2020-05-22 00:00:00 | 20788 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37 | 1.37
41053412 | 2020-06-05 00:00:00 | 20788 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37 | 1.37
41053412 | 2020-06-23 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41053412 | 2020-07-21 00:00:00 | 20788 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41053412 | 2020-07-21 00:00:00 | 20788 | PR RV5 VACCINE 3 DOSE SCHEDULE LIVE FOR ORAL USE [90680] | 0
41053412 | 2020-07-21 00:00:00 | 20788 | PR PCV13 VACCINE FOR INTRAMUSCULAR USE [90670] | 0
41053412 | 2020-07-21 00:00:00 | 20788 | PR DTAP-HEPB-IPV VACCINE INTRAMUSCULAR [90723] | 0
41053412 | 2020-07-21 00:00:00 | 20788 | PR HIB PRP-OMP VACCINE 3 DOSE SCHEDULE IM USE [90647] | 0
41053412 | 2020-07-21 00:00:00 | 20788 | PR IMMUNIZ ADMIN, THRU AGE 18, ANY ROUTE,W COUNSEL, 1ST VACCINE/TOXOID [90460] | 0.17
41053412 | 2020-07-21 00:00:00 | 20788 | PR IMMUNIZ ADMIN, THRU AGE 18, ANY ROUTE,W COUNSEL, EA ADD VACCINE/TOXOID [90461] | 0.15
41052932 | 2020-05-05 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41052932 | 2020-06-08 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,EST,[NAME] IV [99214] | 1.5
41052873 | 2020-06-16 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41052740 | 2020-04-30 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL II [99202] | 0.93
41052383 | 2020-04-24 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,NEW,LEVL II [99202] | 0.93
41052259 | 2020-04-27 00:00:00 | 10410 | PR PREVENTIVE VISIT,NEW,INFANT < 1 YR [99381] | 1.5
41052259 | 2020-05-11 00:00:00 | 10410 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41052259 | 2020-05-18 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41052259 | 2020-06-11 00:00:00 | 10410 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41052259 | 2020-06-25 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41052259 | 2020-06-25 00:00:00 | 10410 | PR DTAP-HEPB-IPV VACCINE INTRAMUSCULAR [90723] | 0
41052259 | 2020-06-25 00:00:00 | 10410 | PR HIB PRP-OMP VACCINE 3 DOSE SCHEDULE IM USE [90647] | 0
41052259 | 2020-06-25 00:00:00 | 10410 | PR PCV13 VACCINE FOR INTRAMUSCULAR USE [90670] | 0
41052259 | 2020-06-25 00:00:00 | 10410 | PR RV5 VACCINE 3 DOSE SCHEDULE LIVE FOR ORAL USE [90680] | 0
41052259 | 2020-06-25 00:00:00 | 10410 | PR IMMUNIZ ADMIN, THRU AGE 18, ANY ROUTE,W COUNSEL, 1ST VACCINE/TOXOID [90460] | 0.17
41050610 | 2020-04-23 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41041273 | 2020-04-27 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41041154 | 2020-07-02 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41040846 | 2020-06-24 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41040622 | 2020-07-01 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41040622 | 2020-07-29 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41040132 | 2020-03-12 00:00:00 | 11498 | PR PREVENTIVE VISIT,NEW,INFANT < 1 YR [99381] | 1.5
41040132 | 2020-04-29 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41040132 | 2020-05-13 00:00:00 | 12554 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41040132 | 2020-05-13 00:00:00 | 12554 | PR PCV13 VACCINE FOR INTRAMUSCULAR USE [90670] | 0
41040132 | 2020-05-13 00:00:00 | 12554 | PR RV5 VACCINE 3 DOSE SCHEDULE LIVE FOR ORAL USE [90680] | 0
41040132 | 2020-05-13 00:00:00 | 12554 | PR DTAP-HEPB-IPV VACCINE INTRAMUSCULAR [90723] | 0
41040132 | 2020-05-13 00:00:00 | 12554 | PR HIB PRP-OMP VACCINE 3 DOSE SCHEDULE IM USE [90647] | 0
41040132 | 2020-05-13 00:00:00 | 12554 | PR IMMUNIZ ADMIN, THRU AGE 18, ANY ROUTE,W COUNSEL, 1ST VACCINE/TOXOID [90460] | 0.17
41040132 | 2020-07-13 00:00:00 | 12554 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41040132 | 2020-07-13 00:00:00 | 12554 | PR PCV13 VACCINE FOR INTRAMUSCULAR USE [90670] | 0
41040132 | 2020-07-13 00:00:00 | 12554 | PR RV5 VACCINE 3 DOSE SCHEDULE LIVE FOR ORAL USE [90680] | 0
41040132 | 2020-07-13 00:00:00 | 12554 | PR DTAP-HEPB-IPV VACCINE INTRAMUSCULAR [90723] | 0
41040132 | 2020-07-13 00:00:00 | 12554 | PR HIB PRP-OMP VACCINE 3 DOSE SCHEDULE IM USE [90647] | 0
41040132 | 2020-07-13 00:00:00 | 12554 | PR IMMUNIZ ADMIN, THRU AGE 18, ANY ROUTE,W COUNSEL, 1ST VACCINE/TOXOID [90460] | 0.17
41039583 | 2020-06-03 00:00:00 | 10410 | PR OFFICE/OUTPT VISIT,EST,[NAME] IV [99214] | 1.5
41039583 | 2020-06-24 00:00:00 | 10410 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41039118 | 2020-03-26 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,NEW,LEVL II [99202] | 0.93
41037932 | 2020-06-22 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41037410 | 2020-06-24 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41037139 | 2020-03-27 00:00:00 | 40248 | PR PHYSICIAN TELEPHONE EVALUATION 21-30 MIN [99443] | 0.75
41037139 | 2020-05-14 00:00:00 | 10410 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41035819 | 2020-07-30 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41035818 | 2020-02-18 00:00:00 | 12306 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41035818 | 2020-02-24 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41035818 | 2020-03-13 00:00:00 | 12306 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41035818 | 2020-03-17 00:00:00 | 11498 | PR PHYSICIAN TELEPHONE EVALUATION 11-20 MIN [99442] | 0.5
41035818 | 2020-04-13 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41035818 | 2020-06-15 00:00:00 | 10410 | PR PREVENTIVE VISIT,EST, INFANT < 1 YR [99391] | 1.37
41035818 | 2020-07-21 00:00:00 | 40248 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41035666 | 2020-05-20 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41034834 | 2020-05-18 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41034456 | 2020-03-09 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41034456 | 2020-04-02 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41034456 | 2020-04-23 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41034456 | 2020-05-22 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41034184 | 2020-07-17 00:00:00 | 12554 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41033728 | 2020-07-13 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41033149 | 2020-02-03 00:00:00 | 12306 | PR OFFICE/OUTPT VISIT,NEW,LEVL III [99203] | 1.42
41033149 | 2020-04-29 00:00:00 | 11498 | PR OFFICE/OUTPT VISIT,EST,LEVL III [99213] | 0.97
41032314 | 2020-02-24 00:00:00 | 12554 | PR PREVENTIVE VISIT,NEW,18-39 [99385] | 1.92
41032314 | 2020-02-24 00:00:00 | 12554 | PR TDAP VACCINE >7 YO, IM [90715] | 0
41032314 | 2020-02-24 00:00:00 | 12554 | PR IMMUNIZ ADMIN,1 SINGLE/COMB VAC/TOXOID [90471] | 0.17
41032314 | 2020-02-24 00:00:00 | 12554 | PR BREATHING CAPACITY TEST [94010] | 0.17
41026896 | 2020-03-09 00:00:00 | 11498 | PR PREVENTIVE VISIT,NEW,18-39 [99385] | 1.92
41026855 | 2020-03-06 00:00:00 | 12554 | PR IIV4 VACC PRESRV FREE 0.5 ML DOS FOR IM USE [90686] | 0
41026855 | 2020-03-06 00:00:00 | 12554 | PR PREVENTIVE VISIT,NEW,40-64 [99386] | 2.33
41026855 | 2020-03-06 00:00:00 | 12554 | PR TDAP VACCINE >7 YO, IM [90715] | 0
41026855 | 2020-03-06 00:00:00 | 12554 | PR IMMUNIZ ADMIN,1 SINGLE/COMB VAC/TOXOID [90471] | 0.17