Part 2/8:
The objective was to aggregate values based on multiple criteria, such as types of data and specified date ranges. The performance of these functions was recorded in milliseconds, allowing for precise measurement of their calculation times.
Initial Findings
All functions tested were impressively quick, with results returning in under a second. However, we noticed notable differences between certain implementations of SUMIFS. The first instance of SUMIFS holds a clear speed advantage due to the arrangement of its conditions. The most restrictive criteria should be placed first to enhance efficiency, particularly when dealing with large datasets.