You may use SUMPRODUCT for this, something like:
=SUMPRODUCT(--(A1:A6="Doctor"),--(B1:B6=1))
Change the ranges and values as appropiate.

Hope this helps

"smiths4" wrote:

Good morning all,

I need to find a formula that can give me a total from two different
columns. example...

Column A is Column C is
Doctor 1
Lawyer 2
Lawyer 2
Doctor 1
Lawyer 2
Doctor 2

And as a result I need the formula to tell me how many doctors have a "1"
rating.

Please help.

Thanks
smiths4