How to Compute SUMIF and AVERAGEIF Problem using Array Formulas

In this video we’re going to explain how to use Excel SUMIF and SUMIFS Functions, and look at a couple of different applications for them. Learning SUMIF extends the capabilities of the basic SUM function by allowing you to tell Excel to only SUM items that meet a certain criteria. Whilst the SUMIFS function, allows you to stipulate multiple criteria, hence the plural. The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria. The AVERAGEIF function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. Learn How to Compute SUMIF and AVERAGEIF Problem using Array Formula in Excel.