Tutorial Playlist

Excel Tutorial

Overview

Your One-Stop Solution to Know About Excel Worksheets

Lesson - 1

Your One-Stop Solution For Excel UserForms

Lesson - 2

The Best Guide on How to Send an Email in Excel

Lesson - 3

Your One-Stop Solution That Will Help You Learn How to Convert PDF to Excel

Lesson - 4

A One-Stop Solution for Acing the Excel MIS Report

Lesson - 5

All You Need to Know About Barcode in Excel

Lesson - 6

Your One-Stop Solution to Learn Mail-Merge in Excel and Its Implementation

Lesson - 7

A Comprehensive Guide on Excel Flash Fill

Lesson - 8

Slicers in Excel: The Ultimate Guide to Help You Design and Develop Excel Slicers

Lesson - 9

One-Stop Solution to Learn Everything About Excel Budget Template

Lesson - 10

All You Need to Learn About Match Function in Excel and Its Real-Time Implementation

Lesson - 11

Everything You Need to Learn on How to Create a Pivot Table From Multiple Sheets

Lesson - 12

The Major Fundamentals About XLookUp in Excel Along With Practical Examples

Lesson - 13

The Ultimate Guide to Learn How to Compare Two Columns in Excel

Lesson - 14

The Best Guide and Your One-Stop Solution to Master the Fill Series in Excel

Lesson - 15

What Is the DATE Function in Excel and How to Implement It?

Lesson - 16

Your One-Stop Solution to Designing and Implementing Hyperlinks in Excel

Lesson - 17

One-Stop Solution to Master Everything You Need to Know About Auto-Sum in Excel

Lesson - 18

DAX in Excel: The Complete Guide for DAX Functions and Formulas in Excel

Lesson - 19

A Perfect Guide for All You Need to Know About Data Formatting in Excel

Lesson - 20

The Perfect Guide to Learn How to Add Columns in Excel

Lesson - 21
One-Stop Solution to Master Everything You Need to Know About Auto-Sum in Excel

Microsoft Excel is a software spreadsheet designed and deployed to manage tabular data, most of which is numbers. Time and again, you might want to add up the numbers to find totals. So, to make things easy, Excel has this inbuilt feature called Autosum in excel.

This article on Autosum in Excel will help you learn the fundamentals of the autosum feature and how to implement it in real-time.

Post Graduate Program in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
Post Graduate Program in Business Analysis

What Is Autosum in Excel?

Autosum in Excel is a built-in summation feature employed to automatically add up the numbers in a few clicks to save time.

Now, in the next section, let us try to practically implement the Autosum feature in excel.

How to implement Autosum in Excel?

Autosum in excel is a simple operation that can be carried out in a few clicks, as shown below.

Consider a sample store data categorized into five different zones and four different quarters, as shown below.

Auto_Sum_in_Excel_1

Now let us imagine a use case where we are supposed to calculate the sum of all sales from all the zones in Q1. Also, let us consider another use case, where we will try to calculate the sum of all sales from one zone throughout the year.

We are considering two use cases as we are trying to implement the Autosum feature in excel row-wise and column-wise. 

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

First Use Case.

We will try to calculate the sum of all sales from Q1 from all four zones. Looking at the sample data, we are supposed to have our result in cell "C7". 

  • Navigate to Cell "C7".
  • Select the" Home" tab on the toolbar
  • Navigate to the editing group 
  • Click on the Sigma symbol as shown below

Auto_Sum_in_Excel_2

  • The Sigma symbol represents summation.
  • To avoid any ambiguities, you can always click on the dropdown and ensure the operation selected is "Summation," as shown below.

Auto_Sum_in_Excel_3

  • Now, after we click on the Sigma symbol, excel will automatically highlight the added cells and implement the summation operation as shown below.

Auto_Sum_in_Excel_4

  • Now press "Enter," The result is stored in Cell "C7".
  • Drag the same cell to all the remaining cells (D7, E7, and F7) to get the results of Q2, Q3, and Q4, respectively.

Auto_Sum_in_Excel_5

Business Analyst Master's Program

Gain expertise in Business analytics toolsExplore Program
Business Analyst Master's Program

Second Use Case

Follow the same method as before. Here we needed the sum of all sales throughout the year from individual zones.

  • To calculate the yearly sales of East Zone, select cell G2
  • Now click on the "Sigma" symbol.
  • Excel will automatically highlight the cells from C2 to F2 and the Sum function.

Auto_Sum_in_Excel_6

  • Press Enter and the result will be saved in G2.
  • Drag the same cell through G3, G4, G5, and G6 to get the results of the West, South, North, and Central zones
  • The result is shown as follows.

Auto_Sum_in_Excel_7

So with that, we have come to an end of this article on autosum in excel. 

Kick-start your career growth story with PGP in Business Analysis. Get a chance to master Excel, Tableau, and Python tools. Start learning now!

Conclusion

"Hyperlinks in Excel" can be your next stop. Hyperlinks can ease up the task of navigating in excel. Whether you want to navigate to a webpage, dashboard, existing document in the local system, or write an email to a friend. All the activities mentioned can be done with a single click using Microsoft Excel.

Are you curious to learn more about Microsoft Excel, receive virtual training, and get certified in the domain of Business intelligence and analytics?

Feel free to go through the Business Analytics certification course offered by Simplilearn. The course offered by simplilearn os is career-oriented and helps you learn according to the current IT standards. Simplilearn's training will help you with the fundamental concepts of data analytics and statistics, enabling you to devise insights from data to present your findings using executive-level dashboards and help you develop data-driven decision-making.

Got any queries for us? Please leave your doubts in the comments section of this "Excel Data Cleaning" tutorial, and our team of experts will be happy to resolve all your questions.

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.