A question for you Excel geniuses

[TheBeast]

I'm not sure if I can do this, but if I can, its probably pretty easy and I'm sure one of you will be able to help me out ... I'm a complete newbie with Excel 🙂

I've got a simple spreadsheet setup, 3 columns wide. First column is a text description, the second column is the number of times an event occured, and the 3rd column is a number between 1-7 which I've made to equal a certain problem.

Example
Column 1: Description Column 2: # of problems Column 3: Number between 1-7 to describe the type of problem
Column 1: Diabetes Column 2: 2 Column 3: 7 (which stands for compliance)

Meaning, for diabetes there were 2 problems found related to #7 which=compliance. What I would like to do is find out how many problems were related to Column 3, number1, column 3 number 2 etc. In order to do that, I need to somehow be able to get my countif to include the numbers in column 2 and link them to column 3. So in the example above, I would like it to count the 7 in column 3 twice since there were 2 problems.

Basically I'Ve got about 400 rows and I'd like to know the # of problems(column 2) that were related to (column 3) number 1 , how many were related to number 2, and so on ...

Did I explain this oK? Is it possible to do this?

 

[ImNoFun]

What about using sort on the data menu to sort by description. Then use subtotal on the data menu to subtotal occurences at each change in column 3. OR after reading more maybe you just want to sort your data by col. 3 and subtotal at each change in column 3.