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:-
Now we will learn how to apply range name in formula syntax:-
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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.