Entering Simple Addition Formula

<div dir="ltr" style="text-align: left;" trbidi="on"> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> The first thing we'll do to our spreadsheet from the previous section is to add up all those numbers, the ones going down under the days of the week headings. The total for each day of the week will be placed on Row 9. So Monday's total will go in cell B9, Tuesday's total will go in cell C9, and so on.</div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Here's our spreadsheet again:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Excel 2007 Spreadsheet" border="1" height="200" src="http://www.homeandlearn.co.uk/excel2007/images/chocAddiction4.gif" width="591" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Our first total will go in cell B9.</div> <h3 align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Adding up in Excel</h3> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Excel needs to know which cells you want to add up. Look at the numbers for the Monday column. We have a 1 in cell B4, a 7 in cell B5, an 8 in cell B6, and a 1 in cell B7. So we want the answer to this:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <b>B4 + B5 + B6 + B7</b></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> To let Excel know that this is what we want, try this:</div> <ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <li>Click inside cell B9, which is where we want the answer to appear</li> <li>Once you've clicked on cell B9, click into the formula bar at the top</li> <li>Type this:</li> </ul> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <b>B4 + B5 + B6 + B7</b></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> When you have entered the formula in the formula bar, press the enter key on your keyboard. Your spreadsheet should look like ours below:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Adding up in Excel 2007" border="1" height="245" src="http://www.homeandlearn.co.uk/excel2007/images/chocAddictionSum.gif" width="366" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Something has gone wrong! This is not quite what we were expecting. We wanted Excel to add up the numbers for us, but it hasn't done anything except enter the cells we typed.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> What went wrong was that we didn't "tell" excel to add up. Excel needs you to type an equals (=) sign first, and then those cell references. If you don't include the equals sign, Excel thinks it's just plain text, and so doesn't do any calculating.</div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> So enter this inside of your formula bar instead:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <b>= B4 + B5 + B6 + B7</b></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> In other words, put an equals sign ( = ) before <b>B4</b>. Press your enter key and you should have the correct answer in cell B9.</div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Now click back inside the formula bar, and delete the equals sign. Press the enter key again. You should then just have the same text as in the image above. We're doing this to show you an easier way to add up - with the SUM function.</div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <br /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> When your spreadsheet looks like ours in the image at the top of the page, you can move on to the next part.</div> </div>

Entering Simple Addition Formula

The first thing we'll do to our spreadsheet from the previous section is to add up all those numbers, the ones going down under the da...

Read more »