You have used the term Sum. Does this mean you want to sum the values in Column c for each of the characteristics or you want a count of Column c for each of the characteristics. This is unclear in your request.
You have used the term Sum. Does this mean you want to sum the values in Column c for each of the characteristics or you want a count of Column c for each of the characteristics. This is unclear in your request.
Alan
Did you debug your code first? http://www.cpearson.com/excel/DebuggingVBA.aspx
Like my answer? Click * below
Database Normalization
Database Principles
Pivot Table Tips
Excel Video Tutorials
SumProduct Video Tutorial
DataPig Access Tutorials
MS Query Tutorial
SQL Tutorial
Bookmarks