Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.

Explanation:

When you want to use the greater, less or equal signs ("<",">","=") in the criteria range of the COUNTIF formula you should include the expression within quotation marks.

Example: =COUNTIF(A1:A8,">=4")

Problem:

A problem arises if you want to use a cell reference in place of the number.
It is wrong to include it within quotation marks.

=COUNTIF(A1:A8, ">=B1") since Excel will identify the cell reference as a string

Solution:

The key is to include only the signs (<,>, =) within quotation marks and use the “&” operator to join (CONCATENATE) them with the cell reference:

=COUNTIF(A1:A8, ">="&B1)
Screenshot // Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.
Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube