Range Name Syntax in Microsoft Excel

MS Excel provides us with many options and functions to create the customized reports and formulas. In this article we are going to teach you, how to use range name in syntax while applying the formula in Microsoft Excel.

Let’s take an example and understand:-

We have a sheet in which we have month wise score details student wise. We just want to return the sum for 4 months.

Now we will create the name range, follow below given steps:-

Select the range B2:B11

Go to Formulas tab > under the Defined Names group > Click on Define name
New Name dialog box will open
Enter the Name and range

Click OK
Follow the same steps for Feb, Mar and Apr month
After defining the name all range will appear in Name Manger
In the formulas tab > Defined names group > click on Name manager

Now we will learn how to apply range name in formula syntax:-

Enter the Sum function in cell B14
While entering the function in cell instead of selecting the range type range name

Press Enter

In the above image, we can see that syntax is showing the range name, sum of the months number are also correct. In this way we use range name as syntax in Microsoft Excel.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com