FILTER.IFS and ASUMIFS Examples

These examples show some of ways that FILTER.IFS and ASUMIFS can be used to calculate dynamic statistics from a data set.

There is an examples workbook in the FastExcel V4 SpeedTools install directory

This example shows how to use FILTER.IFS to filter out data by data type, and how to use ACOUNTIFS to count the occurrences of each data type.

For the same data here are the results of using the ¬ (NOT) operator with data types.