FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.

Detailed explanation-2: -Count nonblank cells in a range by using the COUNTA function Use the COUNTA function function to count only cells in a range that contain values. When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you.

Detailed explanation-3: -ROWS is useful if we wish to find out the number of rows in a range. The most basic formula used is =ROWS(rng). The function counted the number of rows and returned a numerical value as the result.

Detailed explanation-4: -Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list.

Detailed explanation-5: -COUNTIFS applies criteria to cells across multiple ranges, and counts the number of times all criteria are met. This is the syntax of the COUNTIFS function.