The COUNNTIFS function is one of the built-in statistical function, and it can be used as a worksheet function (WS) in Excel. The COUNTIFS function returns the number of cells that meet one single criterion or multiple criteria. The COUNTIF function is a statistical function in Excel which is used to count the number of cells that meet a criterion. The COUNTBLANK function is a built-in statistical function, which can be used as a worksheet function (WS) in Excel. The COUNTBLANK function returns the number of empty cells. The COUNT function is used to count the number of cells that contain numbers, or count the numbers in a list of arguments.
Now use below formula to count the number of cells in the range B2:C5Ĭlick to download COUNTA function sample file Relative Functions: Supposing there are some cells using the IF function as below screenshot shown The COUNTA function count cells except the real empty cell. Sometimes, the cell looks empty but actually contains invisible characters or an empty text “” which is returned by formula. Press Enter key to return the number of cells in the specified ranges.Įxample3 Count cells including empty text “” To count cell number of cells in multiple ranges, using formulas as below: Press Enter key to return the number of cells in the range B2:D5 except empty cells.Įxample2 Count cells in multiple ranges except empty cells
Supposing you want to count cells excluding empty cells, you can use below formula: Usage and ExamplesĮxample1 Count cells in a range except empty cells The COUNTA function returns the number of cells excepted empty cells.
Here B2 will be searched for ‘200’, while D1 to D6 will be searched for ‘300’. For the second one, multiple ranges can be designated. The first one is for a single range (example =COUNTIF(B2:B7,200)), where cells B2 to B7 will be searched for value equal to 200. COUNTIF and COUNTIFS function in Excel 2010Ĭounting cells that match certain criteria is done using COUNTIF and COUNTIFS functions. However, COUNTA function will assume Formula Return Blank as a Non-Blank cell, and will Count it. If cell contain a Formula and formula return’s a BLANK, COUNTBLANK will count it as a blank. In a massive data sheet, this is especially helpful to locate cells containing formula, along with empty cells. In second example, three more arguments has been added, but Excel will treat inserted all arguments as Countable.Īs the name suggests, it counts the blank cells. In below example, it will only count the filled cell, even if cell is filled with a SPACE. Easiest way is to create syntax directly as: =COUNTA (range) in the fx field. COUNTA is usually not present in exel as default in AutoSum menu. Click on the More functions button and run a search for COUNTA. However, excel will treat both arguments as Number, and count them.Ĭounta function in excel is different from the count function. In above formula, two more arguments has been added, 10 & “10”. In the same function, you add multiple Arguments also. In the below screenshot, It’s only Counting Number of cell contain only Number, between B2 to B10. So remember to keep the counting cell in a corner of the worksheet or away from the path of data rows and columns. If you enter any number data later in these cells, the counting cell will automatically update. To count, choose a cell and enter the COUNT syntax: = COUNT (Range).The range is the cells of whom the counting needs to be done, for example cell A1:C6. Purpose of COUNT function is to count number data and ignore text data. You can choose a set of cells that contain number data and check how many of them have numbers. Also it counts only number data and not text data. COUNT function essentially counts numbers, and not adds, a given data in a cell.
They are most definitely not the same and have different purposes. COUNT function in Excel is different from the SUM function.