Question

If you're using COUNTIFS with criteria like the following:

COUNTIFS(priority_level, high)
COUNTIFS(order_no, <40)

Why aren't they showing up correctly?

Option 1: Missing quotation marks around "high"
Option 2: Missing criteria range reference
Option 3: Incorrect use of the less than (<) symbol
Option 4: Missing wildcard character for criteria

Answer 1

The issue with the COUNTIFS formula not showing up correctly is likely due to missing criteria range reference.

Step-by-step explanation:

The issue with the COUNTIFS formula not showing up correctly in this case is likely due to Option 2: Missing criteria range reference. The criteria range is the range of cells that contain the criteria for matching. Without specifying the range, the formula won't know where to look for the criteria.

For example, the correct COUNTIFS formula with criteria could look like this: COUNTIFS(priority_level_range, "high"), where priority_level_range is the range of cells containing the priority level values.

Make sure to properly reference the criteria range to get accurate results.