Multiple aggregation criteria

A very rugged title, isn’t it? When you use multi-conditional data aggeregation functions like SUMIFS, AVERAGEIFS, COUNTIFS, etc. there may be multiple values ​​from one column that you want to consider. This is accomplished by listing these values ​​in curly brackets and then summing all the results. Here’s a quick guide to how to use multiple values ​​for a one criterion.

Multiconditional aggregation of data

Aggregation of data (summarization, counting, averaging) can be done with the help of functions that have one or more of the conditions under which calculation is performed. These are very useful functions because they allow complex analyzes and an efficient way to make summary reports. In the following text we will describe these functions through several examples …