How to countifs if the range contains <> symbols

[MASOODAHMAD]

Hello Everyone,

I am stuck at a point where I'm unable to get the count using the CountIFS formula. My range contains "<" and ">" symbols.

Here's the trimmed version of my data:

Month	AD Type	Print Size
April	CO	<20		WO	9	=COUNTIFS($B$2:$B$14,"WO")
April	WO	<20		<20	0	=COUNTIFS($C$2:$C$14,char(60)&"20")
April	WO	24		<20	0	=COUNTIFS($C$2:$C$14,"<20")
April	CO	35		<20	0	=COUNTIFS($C$2:$C$14,"<"&"20")
April	WO	45		<20	0	=COUNTIFS($C$2:$C$14,E5)
April	WO	<20
April	WO	<20		Less than 20	1	=COUNTIFS($C$2:$C$14,E6)
April	WO	22
April	CO	<20
April	WO	Less than 20
April	WO	<20
April	WO	<20
April	CO	<20

I tried different variations to count the range containing "<20" values. At last, I have to change "<20" to "Less than 20" using a helper column.

Is there a way I can calculate/count such values moving forward?

Thanks in advance.
Masood

 

[RoryA]

You can use:

=COUNTIFS($C$2:$C$14,"=<20")

 

[MASOODAHMAD]

Thank you very very very very very very very very very very muchhhhh…

I was expecting a very simple workaround but didn't think it would be so simple.

 

[RoryA]

Glad we could help.