Using a Range Name in Formula in Microsoft Excel

 

In this article, we will learn how we can use defined range name while calculation in Microsoft Excel.

Let’s take an example to understand.

We have a workbook in which we have 3 lists in 3 columns. Column A contains Jan_2010 sold number to the product, same column B contains the number for Feb_2010, and column C contains the number for the month of Mar_2010.

img1

Follow below given steps to use a range name in a formula:-

  • Define the name to every column.
  • Select the range A1:A13, and define the name in Name box.
  • Write Jan_2010

img2

  • Select the range B1:B13, and define the name in Name box.
  • Write Feb_2010.

img3

  • Select the range C1:C13, and define the name in Name box.
  • Write Mar_2010.

img4

  • Select a cell and type the formula.
  • =Sum(Jan_2010,Feb_2010,_Mar_2010).

img5

  • Press Enter on your keyboard.
  • The function will sum the values to the defined range.

img6

This is the way we can use the formula to define a range name in Microsoft Excel.



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>