How To Use Labels In Microsoft Excel 2003 To Sum Cells

May 27, 2013 robot Uncategorized

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; nevertheless Microsoft has a really great tool which allows you to add up a series of cells simply using the labels around your data. In this article we shall investigate the steps you need to follow along with to be able to use Labels to Sum cells in Microsoft Excel.

Let us begin

To exhibit you how using labels works, the first step we need to undertake is to simply create a new pair of data, so open a Microsoft Excel workbook and click Sheet 1. First off we are likely to build the worksheet so in cell A1 i’d like one 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. These four values we’ve entered into cell A1, B1, C1, D1 are labels. We are now likely to placed into the worksheet three more brands. 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 joined will actually become labels but we will convert them to labels just a little latter on.

In the rest of the cells to put it simply the next values:

B2 – 29 C2 – 32

B3 – 54 C3 – 99

B4 – 62 C4 – 72

Given that a very simple spreadsheet has been built by us and we we have to inform Microsoft Excel to truly recognize brands in our treatments in our spreadsheet have a few values to work. We do this by selecting the Options command from the drop down menu first likely to the Equipment menu and then. The Options dialog box will now be open in front of you. Just choose the Calculation tab and in you need to go through the check box so that it has a check in it and underneath right hand corner you’ll see a box that says Accept Labels in Formulas. Then to accomplish the method just press the OK button.

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

Lets try it out

In cell B5, that is the Values column I want the formula to be typed by you –

= Sum( Values)

The cell must return the total of 145. Though is that the system looked up the column to where the brand was and said every thing in this column what you will discover will be added together. We’re able to have simply typed the next formula rather than using labels –

= Sum( B2:B3)

But, when I am certain that you will agree, using labels makes your supplements a lot easier to read and much clearer to understand. Now it’s your turn. In the cell C5 produce very same brand formula for that cell. I will give you a sign if you are not sure –

= Sum( Values1)

How did that go?

Alright, the next issue we are likely to visit is using numbers as method brands. Now if we just typed in cell D2 the formula –

= Sum( 1999)

All that could be delivered may be the value 1999 and this won’t just work at all. In fact what we have to do is always to inform Microsoft Excel that we need as labels the cells in A4, A3 and A2 to be treated. The first step we must do is always to select cells A2,A3 and A4, then go 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 facing you. All you could only have to complete, to have the cells then press the OKAY button and we chose before thought as Labels is always to press the Add button.

Click once on the cell D2. What we’re going to do now is to enter the same formula I discussed earlier and that is –

= Sum( 1999)

By the way, press the Enter key when you have not done so already. As soon as you do that you should see that it accumulates the values in cells B2 and C2 and you will see the worth of 61 in your cell.

Take to creating the formulas for the other two cells –

D3 = Sum( 2,000)

D4 = Sum( 2001)

Finally, just to finish our spreadsheet down, we can total our total values in cells D2, D3 and D4 by typing the following formula in D4

= Sum( Total)

Using labels in Microsoft Excel is a very clean means of summing your values as it ensures that you don’t miss a address and it makes the formulas a lot simpler. As I’ve seen cases where the blank rows really affected the capability of the application form to work out what was a brand and what is not one problem that I do teach my students isn’t to put blank rows in your spreadsheets. By following design process I outlined above you’ll find that you have absolutely no issues in using cells to be summed by Labels in your spreadsheets.

check this out proximity card