MS Excel: Using SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS Functions

This tutorial demonstrates how to use the following Ms Excel functions:<br />SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS<br /><br />SUMIF - Add values if a condition is met, such as adding up all purchases from one category.<br /><br />SUMIFS function calculates the sum of cells in a range that meets multiple criteria <br /><br />AVERAGEIF Averages only the cells that meet specified criteria. Example: Average the order totals for only London sales<br /><br />AVERAGEIFS returns the average of all cells that meet multiple criteria.<br /><br />#excel <br />#excelfunctions <br />#excelformula