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: -COUNTIF returns the total number of matching values in the range, so you can see if there is more than one matching value. VLOOKUP cannot do this, it only returns the first match. If the value does not exist, COUNTIF will return a zero (0). You do not need to worry about a formula error.

Detailed explanation-3: -What is the COUNTIFS Function? The COUNTIFS Function[1] is categorized under Excel Statistical functions. COUNTIFS will count the number of cells that meet a single criterion or multiple criteria in the same or different ranges.

Detailed explanation-4: -You can use the COUNTIFS function in Excel to count cells in a single range with a single condition as well as in multiple ranges with multiple conditions. If the latter, only those cells that meet all of the specified conditions are counted.