Using COUNTIF function if value to be counted includes < or >

[Human_doing]

Hi everybody,

Can anyone please correct below formula so it will count all instances of >18 in the range? Seems like Excel interprets the > as being part of the calculations rather than part of the string to be searched for and I'm not sure how to sort this. Formula at present is:

=COUNTIF(B2:B51, "<18")

Thanks in advance for any help!

 

[pgc01]

Hi

Try:

=COUNTIF(B2:B51, "=<18")

 

[andrewkard]

Hello, maybe: =COUNTIFS

 

[Aladin Akyurek]

Hi everybody,

Can anyone please correct below formula so it will count all instances of >18 in the range? Seems like Excel interprets the > as being part of the calculations rather than part of the string to be searched for and I'm not sure how to sort this. Formula at present is:

=COUNTIF(B2:B51, "<18")

Thanks in advance for any help!

If you are wanting to count the occurrences of the literal string of >18, try:

=SUMPRODUCT((B2:B51=">18")+0)

 

[nickshep85]

Hi everybody,

Can anyone please correct below formula so it will count all instances of >18 in the range? Seems like Excel interprets the > as being part of the calculations rather than part of the string to be searched for and I'm not sure how to sort this. Formula at present is:

=COUNTIF(B2:B51, "<18")

Thanks in advance for any help!

Your formula is looking for anything that is less than 18 in the range, if you change the < to > then it will give you anything that is above 18.

 

[Human_doing]

Thanks guy for your help, worked perfectly.