Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals by count
Running Excel 2003 Sp1. I have a spreadsheet with 2 colums that I need a
subtotals on. The column A has doctor name in it. Column B has procedure codes in it. The file is sorted by doctor's name and within doctor's name, procedure codes. What I am after is the subtotal of the count of each procedure codes that a dr has done When I use the "DataSubtotal" function, I don't get the results I expect. The following is an exmaple of the raw data and then what I am trying to accomplish. Any help would be greatly appreciated. Raw Data Col A Col B Dr. A Procedure code 1 Dr. A Procedure code 1 Dr. A Procedure code 2 Dr. B Procedure code 1 Dr. B Procedure code 3 Dr. B Procedure code 3 Dr. B Procedure code 5 I need the subtotals to look like this Procedure code 1 count = 2 Procedure code 2 count = 1 Dr. A count = 3 Procedure code 1 count = 1 Procedure code 3 count = 2 Prodedure code 5 count = 1 Dr. B count = 4 Grand totals count for each colum = 7 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals by count
Put it in a pivot table.
See http://www.contextures.com/xlPivot01.html and http://www.peltierteh.com/Excel/Pivots/pivottables.htm -- HTH Bob Phillips (remove xxx from email address if mailing direct) "PineRest" wrote in message ... Running Excel 2003 Sp1. I have a spreadsheet with 2 colums that I need a subtotals on. The column A has doctor name in it. Column B has procedure codes in it. The file is sorted by doctor's name and within doctor's name, procedure codes. What I am after is the subtotal of the count of each procedure codes that a dr has done When I use the "DataSubtotal" function, I don't get the results I expect. The following is an exmaple of the raw data and then what I am trying to accomplish. Any help would be greatly appreciated. Raw Data Col A Col B Dr. A Procedure code 1 Dr. A Procedure code 1 Dr. A Procedure code 2 Dr. B Procedure code 1 Dr. B Procedure code 3 Dr. B Procedure code 3 Dr. B Procedure code 5 I need the subtotals to look like this Procedure code 1 count = 2 Procedure code 2 count = 1 Dr. A count = 3 Procedure code 1 count = 1 Procedure code 3 count = 2 Prodedure code 5 count = 1 Dr. B count = 4 Grand totals count for each colum = 7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
How do I count just the subtotals in Excel? | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
When I subtotal in Excel how can I count the number of subtotals? | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |