COUNT Function The COUNT function returns the number of cells in a range or array that contains numeric values. These values can be integers, decimals, dates or even numbers enclosed in quotations.

The benefit of a last-to-first lookup is that you can find the most recent occurrence of a value in a lookup array that is listed in date order. To achieve this with VLOOKUP, you would have to reverse ...

To count multiple criteria in Excel 2003, you have to create an array formula using the SUM function.

Well-known functions like UNIQUE, COUNTIF, and SORTBY can be used with the spilled range operator to generate dynamic, sortable lists. Using a hash symbol (#)—also known as a spilled range ...

Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.