Counting cells in Excel using the COUNT function is very easy, so if you want to learn how to do it, read this post to learn all about it.

COUNTA function with multiple criteria counts how many arguments are in the list of arguments. Learn how to use COUNTA function in Excel.

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.

Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day. It lets you count cells based on specific text or conditions, turning your spreadsheet chaos into organized data magic.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Mastering Excel COUNTIFS Function What sets COUNTIFS apart from its simpler counterpart, COUNTIF, is its ability to handle multiple criteria at once.

UNIQUE () is available only in Microsoft 365, Excel for the Web, and Excel for Android tablets and phones. For your convenience, you can download the .xlsx demonstration file.