Accountant7
New Member
- Joined
- Oct 21, 2006
- Messages
- 3
I export on-line survey results to an Excel spreadsheet. I need a subtotal of items in each column. Results are labels (Ex: E-Mail, Phone, etc), not numbers. I have many columns and do not wish to use the "COUNTIF function because I will need to identify a COUNTIF formula for each unique instance. There must be an easier way to subtotal columns for each unique label in the column automatically. I am using Excel 2003.