If an inequality sign is specified at the beginning of an aggregate function with conditional judgment, it is treated as a large or small judgment.
As a result, it may not be possible to tabulate as intended.
=COUNTIFS(B3:B6,B2)
Steps
The aggregate result changes when "=" is added to the beginning of the search condition in text merging.
=COUNTIFS(B3:B6,"="&B2)
