The syntax for counting the number of unique values from a list of a column using the array formula is as follows: =SUM(IF(COUNTIF(<first cell from which you count the number of unique values>:<last ...
Like Microsoft Excel, Google Sheets includes a simple COUNT function that tells you the number of items in the selected range. But what if you want to know the number of items based on some condition ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results