“IF” Functions - Home | Western Sydney University

Syntax: COUNTBLANK(range) COUNTIF. Counts the number of cells within a range which meets the given criteria. Syntax: COUNTIF(range, criteria) Example1: COUNTIF(C12:C25,6) - would count all the number 6’s in the range. Example2: COUNTIF(C12:C25,”Alpha”) - would count all the cells with the word “Alpha” contained in the range or list. ................
................