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 ...

Excel doesn’t have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get ...

If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how many cells are empty or if the values of ...

The smartest thing Excel does happens in places you can't see.