Question

Complete the syntax of ‘COUNTIF‘ function:

=COUNTIF (Range, …….…)​

Answer 1

Answer:

COUNTIF counts the number of cells in the range that contain numeric values less than X and returns the result as a number. If you want to count cells that are "less than or equal to 80", use: =COUNTIF(C5:C11,... This formula depends on a helper column, which is added as the first column to the source data table.

Explanation:

hope it is helpful