MS Excel _ Use of SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS functions

This tutorial demonstrates how to use the following Ms Excel functions:
SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS

SUMIF - Add values if a condition is met, such as adding up all purchases from one category.

SUMIFS function calculates the sum of cells in a range that meets multiple criteria

AVERAGEIF Averages only the cells that meet specified criteria. Example: Average the order totals for only London sales

AVERAGEIFS returns the average of all cells that meet multiple criteria.

#excel
#excelfunctions
#excelformula