How To Use Labels In Microsoft Excel 2003 To Sum Cells - 0 views

travel

started by Lyhne Marcher on 11 Jun 13

#1 Lyhne Marcher on 11 Jun 13

Microsoft Excel is a great tool but one particular of its downfalls is the use of cell addresses particularly when you are trying to sum a series of numbers however Microsoft has a truly cool tool that allows you to add up a series of cells just making use of the labels around your data. In this post we will investigate the methods you want to comply with to be capable to use Labels to Sum cells in Microsoft Excel.

Let us get began

To show you how making use of labels operates, the very first step we need to undertake is to basically create a new set of information, so open a new Microsoft Excel workbook and click on Sheet 1. Very first off we are going to create the worksheet so in cell A1 I want you to type - Years, in cell B1 sort the word Values and in cell C1 variety the word Values1 and in cell D1 sort the word Total. These four values we have typed into cell A1, B1, C1, D1 are labels. We are now going to put into the worksheet three more labels. Commercial Www.Tigersealproducts.Com/Products/Packaging/Label Dispensers is a rousing online database for further about when to acknowledge this enterprise. In cell A2 sort the worth 1999, in cell A3 variety the worth 2000 and in cell A4 variety the worth 2001. The last three values entered will in truth grow to be labels but we will convert them to labels a tiny latter on.

In the remaining cells simply put the following values:

B2 - 29 C2 - 32

B3 - 54 C3 - 99

B4 - 62 C4 - 72

Now that we have built a extremely basic spreadsheet and we have a couple of values to work with we have to inform Microsoft Excel to actually accept labels in our formulas in our spreadsheet. We do this by very first going to the Tools menu and then deciding on the Alternatives command from the drop down menu. The Alternatives dialog box will now be open in front of you. Basically decide on the Calculation tab and in the bottom appropriate hand corner you will see a verify box that says Accept Labels in Formulas and you need to have to click on the verify box so that it has a tick in it. Then to comprehensive the approach basically press the OK button.

Now we can use the labels we place in B1 and C1 to add up the values.

Lets try it out

In cell B5, which is the Values column I want you to variety the formula -

= Sum(Values)

The cell should return the total of 145. What you will notice even though is that the formula looked up the column to where the label was and mentioned everything in this column will be added with each other. We could have just typed the following formula instead of using labels -

= Sum(B2:B3)

Nonetheless, as I am sure you will agree, using labels makes your formulas a lot less complicated to study and a lot clearer to recognize. Like Us On Facebook contains extra information about why to flirt with this viewpoint. Now it is your turn. In the cell C5 write the equivalent label formula for that cell. I will give you a hint if you are not positive -

= Sum(Values1)

How did that go?

Alright, the next situation we are going to pay a visit to is making use of numbers as formula labels. Now if we basically typed in cell D2 the formula -

= Sum(1999)

All that would be returned is the worth 1999 so this will not perform at all. Dig up more about www.tigersealproducts.com/products/postal by browsing our thought-provoking site. In fact what we want to do is to tell Microsoft Excel that we want the cells in A2, A3 and A4 to be treated as labels. The initial step we must do is to pick cells A2,A3 and A4, then go to the Insert menu, choose Name from the drop down menu and then decide on the Label command from the expanded menu. The Label Ranges dialog box will now be visible in front of you. All you just have to do, to have the cells we chose prior to defined as Labels is to press the Add button and then press the OK button.

Click when on the cell D2. What we are going to do now is to sort in the very same formula I described ahead of and that is -

= Sum(1999)

By the way, press the Enter essential if you have not done so already. As quickly as you do that you must see that it adds up the values in cells B2 and C2 and you will see the value of 61 in your cell.

Attempt making the formulas for the other two cells -

D3 = Sum(2000)

D4 = Sum(2001)

Ultimately, just to finish our spreadsheet off , we can total all of our total values in cells D2, D3 and D4 by typing the following formula in D4 -

= Sum(Total)

Employing labels in Microsoft Excel is a extremely clean way of summing your values as it guarantees that you do not miss a cell address and it tends to make the formulas a lot simpler. One situation that I do teach my students is not to place blank rows in your spreadsheets as I have observed situations exactly where the blank rows really impacted the capacity of the application to perform out what was a label and what is not. By following the style approach I outlined above you will locate that you have definitely no troubles in making use of Labels to sum cells in your spreadsheets.

<div class="cArrow"> </div><div class="cContentInner">Microsoft Excel is a great tool but one particular of its downfalls is the use of cell addresses particularly when you are trying to sum a series of numbers however Microsoft has a truly cool tool that allows you to add up a series of cells just making use of the labels around your data. In this post we will investigate the methods you want to comply with to be capable to use Labels to Sum cells in Microsoft Excel. Let us get began To show you how making use of labels operates, the very first step we need to undertake is to basically create a new set of information, so open a new Microsoft Excel workbook and click on Sheet 1. Very first off we are going to create the worksheet so in cell A1 I want you to type - Years, in cell B1 sort the word Values and in cell C1 variety the word Values1 and in cell D1 sort the word Total. These four values we have typed into cell A1, B1, C1, D1 are labels. We are now going to put into the worksheet three more labels. <a rel="nofollow" href="http://tigersealproducts.com/products/packaging/label_dispensers">Commercial Www.Tigersealproducts.Com/Products/Packaging/Label Dispensers</a> is a rousing online database for further about when to acknowledge this enterprise. In cell A2 sort the worth 1999, in cell A3 variety the worth 2000 and in cell A4 variety the worth 2001. The last three values entered will in truth grow to be labels but we will convert them to labels a tiny latter on. In the remaining cells simply put the following values: B2 - 29 C2 - 32 B3 - 54 C3 - 99 B4 - 62 C4 - 72 Now that we have built a extremely basic spreadsheet and we have a couple of values to work with we have to inform Microsoft Excel to actually accept labels in our formulas in our spreadsheet. We do this by very first going to the Tools menu and then deciding on the Alternatives command from the drop down menu. The Alternatives dialog box will now be open in front of you. Basically decide on the Calculation tab and in the bottom appropriate hand corner you will see a verify box that says Accept Labels in Formulas and you need to have to click on the verify box so that it has a tick in it. Then to comprehensive the approach basically press the OK button. Now we can use the labels we place in B1 and C1 to add up the values. Lets try it out In cell B5, which is the Values column I want you to variety the formula - = Sum(Values) The cell should return the total of 145. What you will notice even though is that the formula looked up the column to where the label was and mentioned everything in this column will be added with each other. We could have just typed the following formula instead of using labels - = Sum(B2:B3) Nonetheless, as I am sure you will agree, using labels makes your formulas a lot less complicated to study and a lot clearer to recognize. <a rel="nofollow" href="http://tigersealproducts.com/products/postal/ink/pitney_bowes">Like Us On Facebook</a> contains extra information about why to flirt with this viewpoint. Now it is your turn. In the cell C5 write the equivalent label formula for that cell. I will give you a hint if you are not positive - = Sum(Values1) How did that go? Alright, the next situation we are going to pay a visit to is making use of numbers as formula labels. Now if we basically typed in cell D2 the formula - = Sum(1999) All that would be returned is the worth 1999 so this will not perform at all. Dig up more about <a rel="nofollow" href="http://tigersealproducts.com/products/postal">www.tigersealproducts.com/products/postal</a> by browsing our thought-provoking site. In fact what we want to do is to tell Microsoft Excel that we want the cells in A2, A3 and A4 to be treated as labels. The initial step we must do is to pick cells A2,A3 and A4, then go to the Insert menu, choose Name from the drop down menu and then decide on the Label command from the expanded menu. The Label Ranges dialog box will now be visible in front of you. All you just have to do, to have the cells we chose prior to defined as Labels is to press the Add button and then press the OK button. Click when on the cell D2. What we are going to do now is to sort in the very same formula I described ahead of and that is - = Sum(1999) By the way, press the Enter essential if you have not done so already. As quickly as you do that you must see that it adds up the values in cells B2 and C2 and you will see the value of 61 in your cell. Attempt making the formulas for the other two cells - D3 = Sum(2000) D4 = Sum(2001) Ultimately, just to finish our spreadsheet off , we can total all of our total values in cells D2, D3 and D4 by typing the following formula in D4 - = Sum(Total) Employing labels in Microsoft Excel is a extremely clean way of summing your values as it guarantees that you do not miss a cell address and it tends to make the formulas a lot simpler. One situation that I do teach my students is not to place blank rows in your spreadsheets as I have observed situations exactly where the blank rows really impacted the capacity of the application to perform out what was a label and what is not. By following the style approach I outlined above you will locate that you have definitely no troubles in making use of Labels to sum cells in your spreadsheets.</div>

...

Cancel

To Top

Start a New Topic » « Back to the What A High Ranking In Search Engines Can Perform For You group

Start a New Topic