The Awesome SUMIFS, COUNTIFS, and Friends
Alan T. Murray · Apress eBooks · 2022
There is a group of functions in Excel that perform conditional aggregations. The two most well-known functions of this group are the SUMIFS and COUNTIFS functions. However, this also includes the AVERAGEIFS, MAXIFS, and MINIFS functions. And they are awesome.