Count Unique values and summarize totals

I have a workbook I use as my "template" for some projects. I am simple in my excel usage. It is for cable lengths because I work for a place that we need this information. What I have is one column is cable name, one column is cable type, another is cable length. The lengths are fairly standard, say 25', 50' 75' so forth.

I found a function that will count the unique instances at the bottom of we can call it column c, but it just says my total is 5, as 5 different lengths. I want to some how have a function that says 75' 5, 100' 6 and so forth. I want summarize my different instances. How difficult would this be to do?

Matt

You can easily list the different size cables that are available in say column B. In say column C you can use the countif function as follows:

Countif(C?:C?,"="&B?)

You will need to replace the ?'s with your range in column C and the row used to identify the length in column B.

Hope this helps.

I did not understand that entirely.

I made a small example of what I am trying to do there is a comment where I want the sums.

Thank you for the help.

Matt