1.4 Using Aggregate Functions with Named Ranges

Whenever you refer to a named range in a formula, it essentially translates that name into the underlying cell references that the name refers to. Thus, you can use named ranges with aggregate functions such as Average, Sum, Min, Max, etc., and other functions that expect you to pass cell references. The following video shows how you might use some of those functions.