This tutorial demonstrates how to use the following Ms Excel functions:br SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFSbr 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 salesbr br AVERAGEIFS returns the average of all cells that meet multiple criteria.