| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I use vlookup to add multiple values
I'm trying to sort through a long list of medical CPT codes with
corresponding payments. Is it possible to use the vlookup or other function to total all the values that correspond to a certain CPT code? For examle - I have the following list: CPT Amt 10021 223.76 10021 240 10021 215 10021 96.74 10061 57.62 10061 15.37 11400 6 11401 49.39 11401 105.71 11403 63.5 11403 116.85 I would like to total all the amounts for the specific CPT code: CPT Amt 10021 10021 10021 10021 775.5 10061 10061 72.99 11400 6 11401 11401 155.1 11403 11403 180.35 The list has a bout 8000 codes so I'm really looking for something that I can just scroll down. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Vlookup multiple criteria multiple occurrences sum values | Excel Worksheet Functions | |||
| vlookup on multiple values | Excel Worksheet Functions | |||
| Vlookup for multiple values | Excel Worksheet Functions | |||
| vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
Threaded Mode
