explain count function with an example ( answer in detail )
I am mark on brainlist any 5 points give
Answers
Explanation:
Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.
mark as braimliest
What is the COUNT Function?
The COUNT Function is an Excel Statistical function. This function helps count the number of cells that contain a number, as well as the number of arguments that contain numbers. It will also count numbers in any given array. It was introduced in Excel in 2000.
As a financial analyst, it is useful in analyzing data if we wish to keep a count of cells in a given range.
Formula
=COUNT(value1, value2….)
Where:
Value1 (required argument) – The first item or cell reference or range for which we wish to count numbers.
Value2… (optional argument) – We can add up to 255 additional items, cell references, or ranges within which we wish to count numbers.
Remember this function will count only numbers and ignore everything else.
How to use the COUNT Function in Excel?
To understand the uses of this function, let us consider a few examples:
Example 1
Let’s see the results that we get using the data below:
see the pics for that table
please mark as brainlist i need it
