In the example, the formula in F6 is: where “sales” is the named range C4:C10. Other examples of formulas that use this same named range are: Note: named ranges are absolute references by default.
How to create a named range
To quickly create a named range: Video: How to create a named range. More detailed information: Named ranges in Excel. Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.