• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Add Cells in Excel

April 9, 2021 by Andrew Childress
Excel add up column

Gone are the days when you have to reach for your calculator when you start to lean on spreadsheets instead. Heres how to add cells in Excel.

Math is easier when you depend on Excel. Gone are the days when you have to reach for your calculator when you start to lean on spreadsheets instead. This tutorial will teach you how to add cells in Excel for perfect math, every time.

How to Add Cells in Excel

Let’s start off with a simple example to sum up several cells in Excel. In our example, we’re going to use the =SUM function. You can type in the formula, then type in a series of cells (separated by commas) to create a sum of the selected cells.

Check out the example below that points to three cells in an Excel spreadsheet:

Add cells in Excel

Use commas to separate cells in your addition formulas. It’s a simple way to add cells, even if they aren’t near one another.

You can also sum up numbers right inside a formula for simple addition. Here’s an example to try:

=SUM(55,22,14)

How to Add Adjacent Cells in Excel

Often times, your spreadsheet will feature a list of cells next to one another, meaning that they’re adjacent. There are easier ways to add cells in Excel when they’re adjacent.

With an ordered list of data, try out this way of adding cells in Excel. Type in =SUM, then highlight a series of cells in a column. You can click and drag to choose the cells to include in your SUM function. Everything in a continuous range will automatically be added to your formula, as you can see below.

Excel add up column

 

Of course, you can mix and match these formulas. Try a formula like this to sum up a list of data, plus:

=SUM(55,22,14)+SUM(H13:H17)

Before you reach for your calculator, consider opening Excel instead. Use the two functions you learned in this article for perfect additive math, every single time.

 

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Unmerge cells ExcelUnmerge Cells in Excel
Next Post:Axis Labels in ExcelFormat axis titles Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top