Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

A. MurrayAdvanced Excel Formulashttps://doi.org/10.1007/978-1-4842-7125-4_8

8. The Awesome SUMIFS, COUNTIFS, and Friends

Alan Murray¹  

(1)

IPSWICH, UK

 

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.

These functions are quick to learn, as they look very similar to each other. So, once you know one, you kind of know them all. They are an incredibly useful group of functions, especially COUNTIFS.

In this chapter, we will begin with the SUMIFS function. We will understand its ...