Syntax . Value1: The item that you want to look up.It is required. Value2: Additional items in the cell that you want to count. it is Optional. How to use the COUNTA function in Excel ...

Various Count Functions in Excel. If your business uses spreadsheets, ... COUNTA Function. In contrast to COUNT, COUNTA returns a value for the number of non-empty cells in a given range.

How to use COUNTA() to count the items in the unique list in Excel We have the list, so all we need to do is count the number of items in that list using COUNTA() as follows: J3: =COUNTA(H3#) ...