(A) =count
(B) =countif
(C) =counta
(D) =average
If a value meets those conditions, the =countif function returns the total number of times it occurs. The plural type of criterion is criteria, which is a norm or concept for judging, assessing, or choosing something. A decision, assessment, or selection is based on criteria, which are ideals or conditions. Criterion may also be spelled as criterions, although this is rarely used.