Count if not recognising > & < sign

[Excel2021help]

Hi - I have read through a previous thread with a similar question but it is not making sense to me and I am really trying to work this one out. It is probably simple but I am no excel wizz

On sheet 1 I have a list of records and against each one it has a > or < value. For
example >50 or <20

On sheet 2 I have the values listed, for example <10 >10 >20 and I want to count how many
values in sheet 1 have these values

My formula looks like =COUNTIF('sheet1'!$P:$P,$A2) but is just returning a zero - Is this because of the > < signs?

Any help greatly appreciated

 

[Fluff]

Hi & welcome to MrExcel.
Maybe

=COUNTIF('sheet1'!$P:$P,"="&$A2)

 

[Excel2021help]

Hi & welcome to MrExcel.
Maybe

=COUNTIF('sheet1'!$P:$P,"="&$A2)

Well aren't you just a saint! That worked for me - Thank you so much!

Wondering if you could help me possibly break it down a little further.

If in Sheet 1 each record has a > or < value against it and it also has priority of 1, 2 or 3 against it. Is it possible to have the formula look for all the priority 1 values and the count how many have the > or > ?

Thanks again!

 

[Fluff]

As that's a different question, it needs a new thread. Thanks