Working with "< >" symbol inside the formula

[dannwid]

Hello there,

I'm currently working with data that contains > and < symbol as a parameter to classify my numbers. The case goes like this image below.

1st table is my detailed data, I classify them into 3 category (<=25K, >25K - 50K, and >50K)
In the 2nd table i try to COUNTIFS the AAA to count each category but ny Countifs gives me a wrong result. Column Result is my countifs and column "should be" is my manual counting.

Can you guys tell my what went wrong with my countifs?

MY CASE FILE LINK

 

[arthurbr]

Could you please post your formula? Thx

 

[dannwid]

Could you please post your formula? Thx

You can download the file (with formula) by the link inside my post "MY CASE FILE LINK"

 

[Peter_SSs]

C13 formula should be

=COUNTIFS($B$3:$B$8,$B$11,$D$3:$D$8,"="&B13)

 

[dannwid]

C13 formula should be

=COUNTIFS($B$3:$B$8,$B$11,$D$3:$D$8,"="&B13)

THANK YOU, PETER....

Exactly what i'm looking for. I assumed that it had to do with the <> symbol, but i don't know why and how to solve it.

Can you enlighten me, why we need "="& to add in that formula?

 

[Peter_SSs]

THANK YOU, PETER....

Exactly what i'm looking for.

You're welcome, Glad it helped. Thanks for the confirmation.

Can you enlighten me, why we need "="& to add in that formula?

Without the "=" your COUNTIFS is treating the "<=" as meaning "less than or equal to" and not simply as text.
Compare the formulas and results in columns E & F below.

dannwid case 1.xlsx
	D	E	F
2	CLASS
3	<=25K	TRUE	TRUE
4	<=25K	TRUE	TRUE
5	>25K - 50K	TRUE	FALSE
6	>25K - 50K	TRUE	FALSE
7	>50K	TRUE	FALSE
8	<=25K	TRUE	TRUE
Sheet1

Cell Formulas
Range	Formula
D3:D8	D3	=IF(C3<=25000,"<=25K",IF(C3<=50000,">25K - 50K",IF(C3>50000,">50K","")))
E3:E8	E3	=D3<="25K"
F3:F8	F3	=D3="<=25K"