Countif Forumla

**chubbchubb** · 03-20-2014, 07:37 AM

Hi

I am doing some analysis on school data and trying to make my own life easier. In one column I have a list of all the classes a student is in and next to it I have the current grade. The list with the classes has a space between each class code, for example 11a1 11b1 11c1. If I do a countif formula looking for members of a certain class with an A grade I put =Countif(A1:A150,"*a1*",B1:B150,"A") and it works fine.

But what I want is a dropdown list of all the classes as a reference point so if I put the class name in C1 for example that it would change the value based on the class selected. I thought this should work =Countif(A1:A150,"*C1*",B1:B150,"A") but it doesn't return any value. Can someone help me please.

**TMS** · 03-20-2014, 07:41 AM

Maybe:

Formula:

Please Login or Register  to view this content.

Regards, TMS

**chubbchubb** · 03-20-2014, 07:46 AM

Genius! it works well done that man!

**TMS** · 03-20-2014, 10:50 AM

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.