QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Add or Sum in MS Excel 2016?

By Neha T Leave a Comment

Adding is a basic mathematical operation, and is often used during the mathematical calculations. You have a variety of method to add or sum in Excel. One of the popular method to add in excel is AutoSum. It generates the sum of two or more cells in a sheet quickly.

In this section, we will discuss the other options which can also be used to add the cells in excel 2016. We will discuss how we can simply add numbers in the cells using the operator? How we can add using AutoSum, using SUMIF formula? We will also discuss how we can add only selected cells using Filter?

So let us start with the steps to add or sum in MS Excel 2016.

Steps to Add or Sum in MS Excel 2016:

  1. Operator
  2. AutoSum
  3. SUMIF
  4. Filter

Operator

We can simply add the values in several cells using the sum operator (+). Here, you have to select a cell where you want the result of the addition to be stored. In the cell type the formula for adding the desired cells or numbers.

How to add in Excel-01

As you will go on typing the formula, the cells you have mentioned in formula will get highlighted. Below I have given an example of adding the cells using the add operator.

How to add in Excel-02

After typing the formula press enter to obtain the result.

AutoSum

Select a cell just below the column numbers which you want to add and click AutoSum, under the Editing group of Home tab.

How to add in Excel-03

AutoSum directly displays the formula for the sum and also highlight the cell range automatically taken by the AutoSum. You have to press enter to display the result. You can do the same for adding the numbers in a row also.

How to add in Excel-04

Or

You can select the cell range for addition and click AutoSum.

How to add in Excel-05

It will display the addition result just below the last cell of your selected range.

How to add in Excel-06

SUMIF

SUMIF function adds the values of the selected range that validates the given condition/criteria in the formula.

Step 1: In the given example, I have taken the range from B2:B7 and the criteria is that the value of the cell must be >3 then only the cell value will be considered in the addition.

How to add in Excel-07

Step 2: In this example, the result will comprise of the addition of two cell only cell with value 6 and 4.

How to add in Excel-08

Syntax of SUMIF is as below:

SUMIF (range, “criteria”, [sum_range])

Here, the sum_range is optional, but if it is considered, then criteria is validated for the cell values in the range and the corresponding values of the given sum_range are added.

For example,

=SUMIF(A2:A7, “Charles”, B2:B7)

How to add in Excel-09

This will add the values in cell range B2:B7 only if the corresponding cell in the range A2:A7 has the value “Charles”.

How to add in Excel-010

Filter

In case, you need to add only the specific cells then you can use Filter. It will only make you visible the cell that you have selected.

Step 1: Select any cell from your data and click on Filter, in Sort and Filter group under the Home tab, you can also get it under Data tab.

How to add in Excel-011

Step 2: Drop down arrow will start appearing in the column headers. Click on the drop-down arrow of the column whose data you want to filter.

Like, I want to filter the name of the staff members and only want to view the data of Joseph, Charles and Davis. So, I have kept their corresponding checkboxes checked and have unchecked the others.

How to add in Excel-012

Step 3: Now, select the range for addition and click AutoSum to add.

How to add in Excel-013

So, these are the various method you can use while performing addition in excel. Hope you find it interesting and knowledgeable. Keep reading.

You Might Also Like:

Sumif feature imageHow to SUMIF in Excel? count unique values featured imageHow to Count Unique Values in Excel 2016? Subtract feature image 1How to Subtract in Excel? Create a named range in Excel feature imageHow to Create Named Range in Excel? how-to-use-vlookup-in-ms-excel-2016-featured-imageHow to use VLOOKUP in MS Excel 2016? feature imageHow to COUNTIF in MS Excel 2016? enable macro featured imageHow to Enable Macros in Excel 2016? Calculate percentage Featured ImageHow to Calculate Percentage in MS Excel 2016?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Password Protect an Excel file
  • How to Tag Someone on Instagram Post?
  • How to Restore Deleted Files in Windows 10
  • How to Share an Entire Drive in Windows 10?
  • How to Hide the Unity Launcher In Ubuntu 14.04

Copyright © 2023 · QueHow · Contact Us