Summary
You now have theoretical knowledge about formula construction, and should feel confident to perform calculations adhering to certain rules. You are able to construct, edit, and evaluate dynamic arrays as a result of understanding the terms and when to use the function. During the chapter, you have mastered the building of IFS functions and built on the VLOOKUP function by adding the IFERROR and MATCH functions. We explored the new XLOOKUP function, its syntax, and general error returns, and constructed the XMATCH and INDEX functions, too.
We learned about the forgotten database functions and explored working with multiple conditions. Lastly, we recapped the COUNTIF function and worked through examples using COUNTIFS.
In the next chapter, we will explore date functions and look at some more statistical, logical, and mathematical functions, including SWITCH, Subtotals, and SUMIF. In addition, a large part of this chapter will be devoted to PivotTable customization.
