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