Hi,

I have a worksheet that has a list of terms in one column, that vary from 1 to 5 words in length. I want to be able to put in a formula that will detail how many words in the list have 1 word, how many have 2 words, etc.

I also have a list of conditionally formatted cells that show even H/M/L and are colour coded as such. I want also to do a similar thing with these and be able to show how many cells have H, how many have M, and how many have L.

This is also part of a filtered list. If I apply a filter, how can I make the formula do a subtotal so that it only shows the count for the list that is filtered? I know how to do a SUBTOTAL for a filtered list, however not sure how you would apply this to a count of the cells as above.

I have attached an Excel 97 workbook with an example of what I am trying to achieve.

Thanks in advance