Advanced IF functions Charles Stevens October 28, 2015 May 13, 2016 This module will show you how to use advanced IF functions. These are very powerful functions for analyzing information. Introduction Nested IF functions IF with AND and OR COUNTIFS and SUMIFS AVERAGEIFS and IFERROR Introduction Nested IF functions IF with AND and OR COUNTIFS and SUMIFS AVERAGEIFS and IFERROR