FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The COUNTIF function uses the following arguments: Range (required argument) – This defines one or several cells that we wish to count. The range of cells are those cells that will be tested against the given criteria and counted if the criteria are satisfied.

Detailed explanation-2: -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. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)

Detailed explanation-3: -The COUNTIF function counts the number of cells within a range that meet the criteria entered. A filter in Excel displays only a portion of the table data based on matching criteria. A large + sign icon displays next to column headings when a filter is invoked in a table.

Detailed explanation-4: -The COUNTIF function is a Statistical function that counts cells based on a criterion. On the other hand, the COUNTIFS function imposes multiple criteria to multiple ranges then counts those cells that match all the criteria in respective ranges.