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

An Excel sheet containing a list of chores whose numbering increases automatically when another chore is added, thanks to the SEQUENCE and COUNTA functions being used together.

Combining UNIQUE with COUNTA allows you to count the number of unique entries in a dataset. Dynamic array formulas in Excel 365 enhance the flexibility and efficiency of the UNIQUE function.

Q. I’m puzzled. I use the COUNT function to determine how many cells in a worksheet contain numbers and the COUNTA function to tally the empty cells. But when I compare the two results to double-check ...