Similar to other functions, COUNTIF() can reference cells or ranges. However, the condition is altogether another thing. If the condition is in a cell, you’re fine, but that often won’t be the ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.