In the previous chapter, we saw functions such as SUMIFS and COUNTIFS performing aggregations dependent upon criteria. They are incredible functions, but as with everything in life, they have their limitations. You may need to perform aggregations outside of the scope of those functions’ capabilities.
This chapter covers two next-level aggregation functions – SUMPRODUCT and AGGREGATE. These functions are amazing, and each one has specific abilities that make them extremely useful.
We will begin with the SUMPRODUCT function. ...
