The COUNTA Function[1]is categorized under ExcelStatistical functions.It will calculate the number of cells that are not blank within a given set of values. The COUNTA function is also commonly referred to as th
Usingthe COUNTA functioninsidethe SUBTOTAL functioninExcelis to count all the cells that have any type of data. Let us see this in practice. Steps: Go to cellC10and insert the following formula: =SUBTOTAL(3,C5:C9) PressEnterto calculate the total different item types inside cellC10. Meth...
COUNTA function This article describes the formula syntax and usage of theCOUNTAfunction in Microsoft Excel. Description TheCOUNTAfunction counts the number of cells that are not empty in a range. Syntax COUNTA(value1, [value2], ...) The COUNTA function syntax has the following arguments: value...
·The COUNTA function: =COUNTA(value1, [value2], ...) ·Use the COUNTA function for total attendance: In the following example, we usethe COUNTA functionto calculate total attendance. 1. Enter the formula=COUNTA(C5:C11) 2. PressEnterto get the result. As we can see, since 4 cells ...
Read More: Difference Between COUNT and COUNTA Functions in Excel Alternative to COUNTA: COUNTIF Function The COUNTIF function allows you to define criteria for cell ranges, excluding empty cells during counting. In output cell B16, use the formula: =COUNTIF(B5:B13,"<>") Press Enter to get...
If we write a formula in Excel cell =COUNTA(1,2,"Computers","") It will return 4 as the count of cells having values are 4. Here""creates an empty cell but is counted by COUNTA function. Example : All of these might be confusing to understand. Let's understand how to use the fu...
The COUNTA function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COUNTA function can be entered as part of a formula in a cell of a worksheet. Subscribe If you want ...
Use of COUNTA Function with Single argument This example highlights how the COUNTA function in Excel operates. In this case, the formula is applied to a set of six cells, and it determines that five of these cells contain data. At a glance, it might seem confusing because only four cells...
Now use below formula to count the number of cells in the range B2:C5 =COUNTA(B2:C5) Download Sample File Click to downloadCOUNTAfunction sample file Relative Functions: ExcelCOUNTFunction TheCOUNTfunction is used to count the number of cells that contain numbers, or count the numbers in a ...
Cell C9 contains an Excel error. This cell is counted. Cell C10 contains a text string "Text". This cell is counted. Formula in cell F3: =COUNTA(C3:C10) Cell range C3:C10 contains 8 cells, however, only one cell is truly empty. The COUNTA function returns 7 (8-1). I hope this...