How to treat inequality signs as text in the COUNTIFS function.(Microsoft Excel)
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)