Count & Counta formula in Excel

The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel. The COUNTA function counts the number of cells that are not empty in a range.

 

The COUNTA function syntax has the following arguments:

value1 Required. The first argument representing the values that you want to count.

value2, … Optional. Additional arguments representing the values that you want to count, up to a maximum of 255 arguments.