answersLogoWhite

0

The Excel COUNTA function counts the number of cells that are not empty in a range. The syntax is COUNTA(value1, [value2], ...).

See related links for a site that explains the COUNTA function pretty well and has a video for it too.
COUNTA is a function in MS Excel used to count numeric and non-numeric values both Take look at example = COUNTA(A1:A10) it will count all the numeric and non-numeric values present in A1 to A10 cells.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What does the function counter do and what are its parameters?

There is no builtin function 'counta' in C.


Why is counta used?

In Excel, Counta is used to Count the number of cells that are not empty and the values within the list of arguments.


How many parameters are possible using the IF function in Excel?

The IF function has 3 parameters. The condition, the true part and the false part.


What are counta's parametres?

Its parameters can be either a range of cells, a list of individual cells, or even values, which can be numbers text and even blank:=COUNTA(A4,A6,B6,C15)=COUNTA(B2:B25)=COUNTA(1,"A",,,,"Do",2,128)


Excel last cell in a column with an amount in it?

Use 'COUNTA' function. for example: if you want to know the last cell of column B, use the formula below =COUNTA(B:B) It'll give you the cell reference If you want to know the value then use formula below =INDIRECT("B"&COUNTA(B:B))


Does the NUMBER function return the number of cells in the range indentified in the argument contain data?

No. In Excel you would use the COUNT function to do it, or possibly the COUNTA or COUNTIF, depending on exactly what you were trying to do.


What is a name of the Excel function that returns number of cells which are not blank?

COUNTA(value1,value2,...) Value1, value2, ... are 1 to 30 arguments representing the values you want to count.


Which Excel function also has an icon that can be used as a short-cut to achieve the results?

The SUM function, which has the Autosum icon. Other functions can be taken from it, including the Average, Count, Min, Max and Counta functions.


What is the AutoCalculate area that displays the number of cells containing numbers in the selected range?

In Excel you can use the COUNT function to count the amount of cells that have numbers in them and the COUNTA function to count cells that have any kind of data in them.


How do you use count if formulas on excel?

Count cells with numbers: COUNT Count cells with data: COUNTA Count blank cells: COUNTBLANK As an example: =COUNT(A1:A5) =COUNTA(A1:A5) =COUNTBLANK(A1:A5)


How can you simulate GARCH process in Excel?

You need to set up an objective function via Maximum Likelihood Estimation, and then use Excel's Solver to maximize it for estimation parameters. Check out the attached link for an example Excel spreadsheet


What does the COUNT function do in Excel?

The COUNT function counts the number of cells that contain numbers.Syntax: =COUNT(value1, value2,...value30)The arguments (e.g. value1) can be cell references or values typed into the Excel COUNT formula.