Hi

The OP said she did not want sum. She wanted a count of the occurrences.
Bob's solution does just that.

Regards

Roger Govier


milnei wrote:
countif does not sum all the instances, sumif does.

Just try it.

Cheers

Ian