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 ...

How to use COUNTIF with a text condition. The COUNTIF function can also sum items based on text criteria. If you needed to find out how many items in a list have a particular color, you would do this: ...