If you also work with spread-sheets and lot of ranges again and again to create different calculations then you can understand that how hectic it becomes.

But now I have found a solution for this; Named Ranges in Excel because with the help of Named Ranges formulas become so much easier to maintain and understand too.

Previously inExcel Formulas:How to use FILTER Formula in Excel?

With the help of Named Range you can name a cell range, function, constant, or table.

I will use the following table given below for this tutorial. In this table firstly I want to populate the **INR ** and secondly the **Sum of the USD** columns:

Follow these steps to know how to do this in your Excel:

**STEP 1:** firstly you need to create your first Named Range by highlighting the USD Amounts and typing a name in the **Name Box**: *Amounts*

*Amounts*

Now complete it by doing this same to your **INR** by highlighting the exchange rate and typing a name in the **Name Box: USDRate**

**STEP 2:** In second step I’m going to see the Named Ranges in action.

Now type in: =**A2*USDRate ;** to calculate the **INR Totalcolumn**.This is going to use your ** USDRate **Named Range like this:

To get the calculated amounts apply this same formula to other remaining cells by dragging the corner.

**STEP 3:** here in final step type in following to calculate the sum of the **Sum of USDcolumn**: =**SUM(Amounts)**.

Now our **Amounts **Named Range will be used:

**STEP 4:** to check all the created Named Ranges follow this Go to **Formulas > Defined Names > Name Manager**

Now if you want to edit your Named Ranges or delete them you can do it easily.