View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carl Schreiner[_2_] Carl Schreiner[_2_] is offline
external usenet poster
 
Posts: 2
Default countif/sumif with multiple variables

I am working on sorting through a database of medical CPT codes and would
like to get the total number of proocedure codes with the total amount of
reimbursement for each code. If been able to use countif and sumif to get
the totals but there are mutiple cases where there are mutiple reimbursements
for a given date so the number of codes is skewed high. I would like to
total the code and reimbursement ONLY if the name, date, and code all match:

name date code $
jane 3/1/2009 99204 50
joe 3/1/2009 99204 25
jane 3/1/2009 99204 30
joe 3/2/2009 31235 150
mark 3/3/2009 31235 140
sue 3/3/2009 31237 200

expected result:
code total $
99204 2 105
31235 2 190
31237 1 200

note that the total for 99204 is 2 instead of 3 because the name and date
were the same. Any ideas?