=COUNTIF(D5:D12,">100") // count sales over 100 =COUNTIF(B5:B12,"jim") // count name = "jim" =COUNTIF(C5:C12,"ca") // count state = "ca" =COUNTIF(A1:A10,100) // count cells equal to 100 =COUNTIF(A1:A10,"<"&B1) // count cells less than B1
References
https://exceljet.net/excel-functions/excel-countif-function