Consolidation function - for just text

[Jon Johny]

Im using the consolidate function in Excel 2007. I have a table that does'nt have numbers, just text. Therefore, I do not require a count or sum or anything like that. The consolidated table I created gives me the pulled pulled, but under everyline, it the consolidated table performs a count subtotal. How do I create this without the count subtototals appearing??

Thank you,

 

[Jon Johny]

This question never got answered, does anyone have any suggestion???