Both Excel tables and dynamic array formulas are containers for automatically expanding data. So, if you try to put one thing that automatically expands (such as a dynamic array formula) inside ...

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

Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.