News
Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.
Excel has SumIf and CountIf, but no AverageIf. However, with a little array magic, you can get Excel to average values, conditionally.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback