You can use the COUNTIF function in Google Sheets to find the number of items in a range that meet certain criteria.

Both function combinations will skip over any blank row and will not count towards the running total of unique values, as there is no value to be counted.

In other words, we're telling Excel to count the number of animals the UNIQUE function returned in the spilled array starting in cell D2, and that this number may change.

When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful. For example, suppose you have entered your final letter grades, and you need to report how ...

There is no COUNTIF function in Microsoft Power BI. If you need to apply that logic, you’ll have to turn to other measures.

Discover 5 powerful Excel alternatives to XLOOKUP, including XMATCH, COUNTIF, and Power Query, to enhance your data analysis skills.