Advanced IF Functions

In addition to the basic IF function, Excel has several conditional functions that you can use to aggregate data based on certain conditions. There are functions like IFS, SUMIF, SUMIFS, COUNTIF, AVERAGEIF etc. also referred to as advanced IF functions which we’ll be covering in this section. For example, the IFS function can be used in place of convoluted nested IF statements. There are also several conditional aggregate functions that enable you to use one function in place of 2 or more functions.