COUNTA Articles: Excel and Google Sheets

The COUNTA function in Google sheets is one of the simplest and most used functions. It is very similar to COUNT in syntax and use. The Google Sheets COUNTA function counts the total number of values within a range. In this tutorial, you will learn how to use the COUNTA...

When you enter data in Excel, you sometimes do it with a lot of cells left blank to fill them at a later stage when data is available. When you want to count the number of entries you made in a cell range, then you need a specific function in Excel to...

Excel has many specialized functions to perform various unique calculations and some calculations are performed with combination of two or more functions together. When we talk about counting cells containing specific values then we need to deal with COUNT and COUNTA functions in Excel. Syntax of both of these functions...

Excel allows a user to count all cells that contain any value, by using the COUNTA function.  The function takes in count texts, numbers, spaces, results of other function, etc. This step by step tutorial will assist all levels of Excel users in counting non-blank cells in a range. Figure...