How To Use Labels In Microsoft Excel 2003 To Sum Cells

Izvor: KiWi

Microsoft Excel is a great tool but one of its pitfalls is the use of cell addresses specially when you are trying to sum a of numbers; however Microsoft has a really cool tool which allows you to incorporate up a series of cells simply utilizing the labels around important computer data. In this article we shall investigate the steps you'll need to check out to have the ability to use cells to be Summed by Labels in Microsoft Excel.

Let's begin

To show you how using labels works, the first step we need to tackle would be to simply develop a new group of data, so open a Microsoft Excel workbook and select Sheet 1. First off we are likely to build the worksheet so in cell A1 I want you to type - Years, in cell B1 type the word Values and in cell C1 type the word Values1 and in cell D1 type the word Total. For a different perspective, please check out: mifare cards. These four values we have typed into cell A1, B1, C1, D1 are labels. We are now going to placed into the worksheet three more labels. In cell A2 type the value 1999, in cell A3 type the value 2000 and in cell A4 type the value 2001. The last three values entered will actually become labels but we will change them to labels a little latter on.

In the rest of the cells in other words the next values:

B2 - 29 C2 - 32

B3 - 54 C3 - 99

B4 - 62 C4 - 72

Since a very simple spreadsheet has been built by us and we we've to inform labels to be actually accepted by Microsoft Excel in our formulas in our spreadsheet have a couple of values to work. We do this by choosing the Options command from the drop down menu first going to the Equipment menu and then. The Options dialog box will now likely be operational in front of you. Simply pick the Calculation tab and in the bottom right hand corner you'll see a box that says Accept Labels in Formulas and you need to click on the check box so that it has a break in it. Then to complete the procedure simply press the OK button.

Now we will use the labels we place in B1 and C1 to incorporate up the values.

It is tryed by lets out

In cell B5, that will be the Values column I would like the formula to be typed by you -

= Sum( Values)

The cell must reunite the full total of 145. However is that the formula looked up the column to where in actuality the label was and said everything in this column what you'll notice will be added together. We're able to have just typed the next formula as opposed to using labels -

= Sum( B2:B3)

Nevertheless, when I believe you'll agree, using labels makes your treatments much better to know and easier to read. Now it's your turn. In the cell C5 write the same label system for that cell. Discover extra information on our related website - Navigate to this link: TM. I will give a sign to you if you are uncertain -

= Sum( Values1)

How did that go?

Alright, the next problem we're going to visit is using numbers as method brands. Now when we simply keyed in cell D2 the formula -

= Sum( 1999)

So this won't work on all all that might be delivered may be the price 1999. In fact what we should do is always to tell Microsoft Excel that we want as labels the cells in A2, A3 and A4 to be treated. The first faltering step we must do is always to choose cells A2,A3 and A4, then head to the Insert menu, choose Name from the drop down menu and then choose the Label command from the expanded menu. The Label Ranges dialog box will now be visible in front of you. All you could simply have to complete, to have the cells then press the OK button and we chose before thought as Labels would be to press the Add button.

Click once on the cell D2. What we are going to do now is to key in the exact same formula I discussed earlier and that is -

= Sum( 1999)

By the way, press the Enter key when you have not done so already. The moment you do that you should see that it can add up the values in cells B2 and C2 and you will see the worthiness of 61 in your cell.

Take to creating the formulas for the other two cells -

D3 = Sum( 2000)

D4 = Sum( 2001)

Finally, simply to finish our spreadsheet off, we can total all of our total values in cells D2, D3 and D4 by typing these formula in D4

= Sum( Total)

Using labels in Microsoft Excel is a very clear method of summing your values as it means that you do not skip a address and it makes the formulas a great deal simpler. One issue that I do teach my students isn't to place blank rows in your spreadsheets where in fact the blank rows really affected the ability of the applying to sort out what's not and what was a brand as cases have been seen by me. Clicking mifare cards probably provides aids you could tell your family friend. Browse here at the link mifare cards to compare where to allow for it. By after the design process I outlined above you'll find that you've absolutely no issues in using cells to be summed by Labels in your spreadsheets.