Aggregate With OR Logic in Microsoft Excel

Excel users who want to learn how to streamline their work click here 👉 https://affiliate.excel-university.com/idevaffiliate/idevaffiliate.php?id=237&url=33

The family of IFS functions, such as SUMIFS and COUNTIFS, use AND logic when evaluating multiple conditions. In other words, all conditions must be true to be included. And generally, this logic works well. However, there are situations when we'd like to use OR logic instead. That is, any of the conditions can be true to be included.

In this video, we'll talk about how to aggregate using OR logic. In summary, we'll determine the values to include with the FILTER function and then wrap the desired aggregation function (SUM, COUNT, AVERAGE, MIN, MAX, ...) around it.

Видео Aggregate With OR Logic in Microsoft Excel канала Excel University