Using Formulas for Conditional Analysis
Michael Alexander, Dick Kusleika, John Walkenbach · 2018
Excel provides several worksheet functions for performing conditional analysis. Conditional analysis means performing different actions depending on whether a condition is met. Simple conditional functions like IF generally work on only one value or cell at a time. Excel provides some different conditional functions for aggregating data, such as summing or averaging. This chapter discusses some of the techniques for applying calculations based on a given set of conditions. Excel provides the SUMIF function to sum values based on a condition. One way that the user can use SUMIF with two or more conditions is to add or subtract multiple SUMIF calculations. If the two conditions operate on the same range, this is an effective way to use multiple conditions. Microsoft introduced AVERAGEIFS along with SUMIFS and COUNTIFS to allow user to average a range of numbers based on more than one condition.