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 attempting to sum a of numbers; nevertheless Microsoft has a really great tool that enables you to add up a series of cells simply utilising the labels around your computer data. In this article we shall examine the steps you’ll need to follow along with to be able to use cells to be Summed by Labels in Microsoft Excel.

Let’s get started

Showing you how using brands works, the first step we have to undertake would be to simply develop a new pair of data, so open a Microsoft Excel workbook and select Sheet 1. To start we’re 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 typed into cell A1, B1, C1, D1 are brands. We are now going to put in the worksheet three more brands. In cell the value is typed by A2 1999, in cell A3 type the value 2000 and in cell A4 type the value 2001. The past three values joined will in reality become labels but we will change them to labels just a little latter on.

In the residual cells in other words the following values:

B2 – 29 C2 – 32

B3 – 54 C3 – 99

B4 – 62 C4 – 72

Given that we have created a really simple spreadsheet and we have a couple of values to work with we have to tell labels to be actually accepted by Microsoft Excel in our treatments in our spreadsheet. We do this by choosing the Options command from the drop down menu first planning to the Equipment menu and then. The Options dialog box will now be open facing you. Simply pick the Calculation tab and in the bottom right hand corner you will see a box that states Accept Labels in Formulas and so that it’s a tick in it you need certainly to go through the check box. Then to complete the procedure simply press the OKAY button.

Now we will use labels we devote B1 and C1 to include up the values.

It is tryed by lets out

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

= Sum( Values)

The cell must reunite the sum total of 145. However is that the method looked up the column to where in actuality the brand was and said every thing in this column what you’ll discover will be added together. We could have simply typed the following formula instead of using labels –

= Sum( B2:B3)

But, when I am certain that you’ll agree, using labels makes your supplements much better to comprehend and a lot easier to read. Now it is your turn. In the cell C5 produce very same tag system for that cell. I will give you a tip if you’re uncertain –

= Sum( Values1)

How did that go?

Okay, another problem we are planning to visit is using numbers as system labels. Now when we just typed in cell D2 the system –

= Sum( 1999)

All that might be returned is the price 1999 and this will not just work at all. Actually what we need to do is to inform Microsoft Excel that we want the cells in A2, A3 and A4 to be treated as labels. The first step we ought to do is to select cells A2,A3 and A4, then head to the Insert menu, choose Name from the drop down menu and then choose the Label control from the expanded menu. The Label Ranges dialog box will now be visible facing you. All you only have to accomplish, to have the cells we chose before understood to be Labels is to press the Add button and then press the OKAY button.

Click once on the cell D2. What we’re likely to do now is to enter exactly the same system I mentioned before and that is –

= Sum( 1999)

By the way, press the Enter key if you have not done so already. When you do that you must see that it accumulates the values in cells B2 and C2 and you’ll see the worth of 61 in your cell.

Try making the formulas for another two cells –

D3 = Sum( 2000)

D4 = Sum( 2001)

Finally, just to end our spreadsheet off, we could total all of our total values in cells D2, D3 and D4 by typing the next method in D4

= Sum( Total)

Using labels in Microsoft Excel is a very clean means of summing your beliefs as it ensures that you do not skip a address and it makes the remedies a great deal simpler. One issue that I do show my students isn’t to put blank rows in your spreadsheets where the blank rows actually affected the power of the applying to work through what was a brand and what is not as cases have been seen by me. By following the design process I outlined above you will find that you have simply no difficulties in using cells to be summed by Labels in your spreadsheets.

get more info proximity card