I have a form with answers such as: < 24
or > 20 kh
I want to count how many answer are of each type. I want to use a formula of this kind: =COUNTIF(EW5:EW150;"< 24")
but it seems that Excel treats "< 24" as: inferior to 24, whereas I want Excel to treat it as a simple string of characters.
How can I do this?
Thank you
If you apply SUM and IF separately the required result is returned.
=SUM(IF(EW5:EW150="< 24",1,0))