Subtotaling Labels

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.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Why not use Data>Subtotals...?
 

Accountant7

New Member
Joined
Oct 21, 2006
Messages
3
Question Using Data Subtotals

I am working with data subtotals and have not figured it out yet. I have 7 columns of data (each contains labels) side by side across the page. Each columns requires a subtotal of unique labels or words in it. Can I select all 7 columns at once and produce subtotals below each for each unique labels in a column?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Can you post some sample data?

It's not 100% clear how it is structured.
 

Accountant7

New Member
Joined
Oct 21, 2006
Messages
3
Column 1 Column 2 Column 3
not applicable Ford Ford;Subaru;Jeep
not applicable Chrysler Chrysler
not applicable Chevy Chevy;Dodge
not applicable Ford;Chevy Ford;Chevy;Toyota

Thanks you!!
 

Forum statistics

Threads
1,136,427
Messages
5,675,777
Members
419,585
Latest member
popsin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top