Countif

COUNTIF is an Excel function which allows for the counting of values in a range where the values meet a criterion.

Named

Anything named - objects, variables, classes..

Others

Example |
---|

The roundabout method i ve employed is to create additional columns with a regular countif and counta formulae - in other words i count the number of countries a named has visited from question Array Formula Conditional Count |