This is what I am trying to find:

Of the people in column 'A' who identified as a "2", what percentage also
identified as a "5" in column 'B'? --

I have no clue what formula to use - I tried using COUNTIF combined with IF
and thought it was right, but now certain numbers aren't working out
correctly. Then i thought maybe I needed to use AND as I'm trying to find two
things??

If anyone can give me a template using my information above, that would be
fantastic! Thank you!