Google-spreadsheet has a built in function (COUNTUNIQUE) that will count the unique entries in a range. Excel has had a long standing SUMPRODUCT(1/COUNTIF(...)) equivalent. [count-unique] is for the complex application of these functions/formulas with criteria and range adjustment.