Who else wants to know the secret to Excel Formulas?Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today
Have you ever wanted to figure out what the total would be if you added two cells together in Excel? There is a really simple way to do it – without your calculator. Let me explain how….
- Make sure you have typed your numbers into Excel in different cells
- Select the cell you want to have the total appear in (it may make sense to be below the numbers you just typed in)
- Once you have clicked on the cell, type an equals sign, select the first cell, type a plus sign, then select the second cell, then hit enter
- You should now see the total of the two cells!!!
If you click on the cell with the total in it, you will notice something we call a formula. In this case it might look like “=A1+A2 “. The best way to figure out what the formula in the cell is calculating is if you read it out loud. In this case it says “this cell equals whatever is in A1 plus whatever is in A2”.
So there you have it – the simple way to add two cells together in Excel (and your introduction to formulas!)
’till next time!