Adding Cells In Excel - How To Add Cells Together In An Excel Spreadsheet Explained

In this video we discuss adding cells, or how to add cells in an excel spreadsheet. We go through a couple of examples including how to add cells together that are in different columns and rows

Transcript/notes
In this excel spreadsheet we have values in cells a1 thru a3, (122,31,57) and let’s say that we want to add these cells together and put the answer in cell b4.

One of the easiest ways to do this is to start by left clicking on cell b4, so it is highlighted, then we type in the equals sign, next we left click on the first cell we are adding, in this case cell a1, then we type in a plus or addition sign, next, we left click on the next cell we are adding, cell a2, then we type in another plus sign. And then we left click on the next cell we are adding, cell a3. Next we finish by hitting the enter key and we get an answer of 200.

And the cells you are adding together do not need to be in the same column or row, as you see in this example, where I am adding cells e1, f3, g2 and cell d4 together.

[tomprovan]

vary useful some people get to complicated thank you

[mlbullbooks]

Thank you. I totally forgot how to do this properly.