Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF with multiple variables HELP!!!! | Excel Worksheet Functions | |||
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
multiple criteria with countif or sumif | Excel Worksheet Functions | |||
COUNTIF() With multiple ranges and variables | Excel Discussion (Misc queries) | |||
Sumif with multiple variables | Excel Discussion (Misc queries) |