CountEqual
Counts the number of values in a value set that are equal to a specific value.
Syntax
CountEqual(param1, param2, ..., value)NbEgal(param1, param2, ..., value)
param1 = first parameter in the set (value, range, or list)
param2 = second parameter in the set (value, range, or list)
... = nth parameter in the set (value, range, or list)
value = value that the values must equal in order to be counted
Remarks
This function accepts an unlimited number of parameters.
If you want to count the number of values based on a comparison other than equality, see CountIf.
Examples
CountEqual(1, 2, 3, 2.5) = 0CountEqual(1, 2, 3, 3) = 1CountEqual("b", "b", "c", "b") = 2