Site icon ExcelNotes

How to Count Cells that are Above Mode

The COUNTIF function counts the number of cells that meet one criterion, such as the cells with a text string, the cells with a certain value, etc. The MODE function returns the most frequently occurring or repetitive value in an array or range of data.

Example: You are working with a dataset with the first name in column A, the last name in column B, and the salary in column C.

Formula 1: To count the number of cells that are greater than the mode

= COUNTIF(C2:C12, ">"&MODE(C2:C12))

The mode of column C (C2:C12) is $70,256.00, and five values in column C are greater than the mode.

Formula 2: To count the number of cells that are less than the mode

= COUNTIF(C2:C12, "<"&MODE(C2:C12))

The mode of column C (C2:C12) is $70,256.00, and three values in column C are less than the mode.

Notes: The COUNTIF function

Formula:

= COUNTIF(Range, "=number")

Explanations:

– The range is required, the range of cells you want to count;
– The number is required, which is the base number.

Exit mobile version