One way to manage data sets is to define and name a range of data. Naming a range makes it easier to use that set of data in a formula, function or chart. These examples use named ranges to create logical and statistical functions. The functions demonstrated include: IF, SUMIF, AVERAGEIF, COUNTIF, IFERROR. Learn to use this powerful tool to simplify data for yourself and others.
