LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF with multiple variables HELP!!!! Gwynne Excel Worksheet Functions 2 August 12th 09 05:20 PM
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter Greg in CO[_2_] Excel Worksheet Functions 0 September 18th 08 05:51 PM
multiple criteria with countif or sumif Renee Excel Worksheet Functions 2 July 28th 06 02:01 PM
COUNTIF() With multiple ranges and variables Thansal Excel Discussion (Misc queries) 3 July 12th 06 05:32 PM
Sumif with multiple variables les8 Excel Discussion (Misc queries) 5 April 8th 06 02:16 AM


All times are GMT +1. The time now is 10:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"