How to Add Two or More Cells in Excel

Calculate cell values automatically in Excel
by Updated January 29, 2009

This step by step shows you how to add three cells together in Microsoft Excel to get the cells total count.

  1. Open the Excel workbook or worksheet file to use.
  2. Click on the cell where you want the Total count to be placed. (In the example shown in the accompanying image, it is cell B24)
  3. Press the = key on the keyboard. You will see the equal sign in both the cell and the Formula Bar.
  4. Click on the first cell that you would like to add. (In this example, it is cell B7)
  5.  Press the + key.
  6. Click on the second cell that you would like to add. (In this example, it is B12)
  7. Press the + key again.
  8. Click on the third cell that you would like to add. (In this example it is B20). You will now see the following in the Formula Bar: =B7+B12+B20
  9. Press Enter on the keyboard to finish the equation and view your Total count.

Note: Using this process you can add cells located anywhere in your Excel spreadsheet. In other words, the cells that are being added together do not have to be in the same column or row, nor does the resulting cell total.

 


0
0

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:

Comment:
Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts


This tutorial will teach you how to use the SUM function in Microsoft Excel to add column values together in order to calculate a total amount.  more »

The following is a step-by-step example of how you can easily import delimited text files into Microsoft Excel. You can use the Excel Text Import Wizard to quickly import files delimited by Tab, Semicolon, Comma (also known as Comma Separated Value (CSV) file format), Space or Other (you choose), or divided by fixed width columns.  more »