Use COUNTIF, one of the excel functions, to count the number of cells that meet a criterion
From Microsoft :
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?)
https://support.microsoft.com/en-us/o...
