FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Excel COUNTIF function is used for counting cells within a specified range that meet a certain criterion, or condition. For example, you can write a COUNTIF formula to find out how many cells in your worksheet contain a number greater than or less than the number you specify.

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 difference is that COUNTIF is designed for counting cells with a single condition in one range, whereas COUNTIFS can evaluate different criteria in the same or in different ranges.