EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Functions Excel Column Total
Secondary Sidebar
Excel Functions
  • Excel Functions
    • Excel Column Total
    • VLOOKUP to Return Multiple Values
    • User Defined Function in Excel
    • Excel SWITCH Function
    • Excel FV Formula
    • Excel AVERAGEIF
    • Simple Formula in Excel
    • Excel Scatter Chart
    • Excel Bar Chart
    • LINEST Excel Function
    • RANK Excel Function
    • Excel MOD Function
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Certification Course
  • EXCEL Certification COURSE

Excel Column Total

By Madhuri ThakurMadhuri Thakur

Excel Column Total

Excel Column Total (Table of Contents)

  • Definition of Excel Column Total
  • Examples of Excel Column Total

Definition of Excel Column Total

In excel there are various methods to know the total of numbers inside a column, in this article we will discuss those methods and shortcuts that how do we identify the total sum of numbers in a column. First, we should understand what is the basic definition of Excel Column Total we are talking about. Column Total means the sum of the numbers present inside a column. Now let us go through with various examples on how we can get Totals of Columns in Excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,412 ratings)

Examples of Excel Column Total

Let us discuss examples of Excel Column Total.

You can download this Column Total Excel Template here – Column Total Excel Template

Example #1

Let us begin with the most basic method to know the total of numbers in a column. In this method, we will select a column to see what is the total of the column.

1. Let us make a table of data in sheet 1 as shown below:

Excel Column 1

2. Now select whole column B as shown in the image below:

Excel Column total 2

3. In bottom right corner we can see on the status bar that excel automatically calculates the total of the column for us. Refer below screenshot for the preview,

Excel Column total 3

This status bar excel shows us what is the total of column B as Sum which is 527.

Example #2

For example one we have seen how excel has given us total by selecting the total column. But what will happen if we select only the data range in the column rather than the entire column. Let us find out in this example,

1. Let us use the same data from sheet 1 for this example too.

2. Instead of selecting the entire column as we did in example 1, we will select only the data range as shown in below image:

Excel Column total 2

3. Now in the same status bar in the bottom right corner let us check the total as result, it will be same as we have seen in example 1,

Excel Column total 3

So even we select the data range in the column or we select the entire column we will get the same total as result.

Note: Now there is a catch for both example 1 and example 2 that these totals in the columns are temporary means the total can change as soon as the data will change, in the column for example till B7 we had data in the column and if we increase data in B8 the total will increase.

Example #3

In the above examples, we have seen that how excel calculates temporary total in the status bar, however, there are some inbuilt formulas through which a user can calculate the total of the columns in excel by himself, one of such formulas is known as Auto Sum function. It is an inbuilt function in excel which calculates the sum of the numbers of the given data range. There is a keyboard shortcut to use the Auto Sum function in excel which is ‘ALT” + “=” buttons.

1. Now let us copy the same data from sheet 1 to sheet 2 for our data table as shown below:

Excel Column 1

2. In B8 cell let us press the keyboard shortcut we talked about above and see the result as follows:

excel column total example 3-1

3. Excel will automatically compute the sum from the data range in the given column, when we press Enter we will get the result as follows:

example 3-3

Example #4

Apart from Auto Sum in Excel which is initiated by a keyboard shortcut, there is an inbuilt sum function in excel which allows us to select specific cells in any columns in excel to compute sum in the columns. Let us use the sum function in this example.

1. In the same data table in cell B9 enter the following formula as shown below:

example 4

2. Press “Tab” button from keyboard for the sum function and select the data range from the table as shown in the below image:

example 4-1

3. When we press Enter we will see the result of the sum of the numbers from B2 to B8, remember that in cell B8 we already have the sum of the numbers from B2 to B7.

example 4-2

Explanation of Excel Column Total

In any worksheet of excel data is present in both rows and columns in form of cells. Each individual cells contain data, when these cells contain numbers excel automatically gives us certain features to calculate the total of these numbers by different methods. Some of the methods are inbuilt which is a feature of excel but they give us temporary result, while the formulas which are used to calculate the total of the numbers give us permanent results.

How to Use Excel Column Total?

As we have discussed in the above examples we have seen that there are four methods to calculate Excel Column Total and they are as follows:

  1. First is by selecting the entire column.
  2. The second method is by selecting the data range in the column.
  3. In the third method, we had used the Auto sum function to calculate the total.
  4. The best procedure to calculate the total is by using the sum function.

Things to Remember

There are few things to remember about Excel Column Total and they are as follows,

  1. Column Total Means the sum of numbers in a given column.
  2. When we select a column for column total it ignores the header and calculates the sum of the numbers in a given column.
  3. Auto Sum function only calculates the sum from the data range above the function.
  4. By using Sum function we can select certain cells for which we want the total in the column.

Recommended Articles

This has been a guide to Excel Column Total. Here we discuss How to Excel Column Total along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Column Header in Excel
  2. Freeze Columns in Excel
  3. COLUMNS Formula in Excel
  4. Moving Columns in Excel
Popular Course in this category
MS Excel Training Bundle
  13 Online Courses |  100+ Hours |  Verifiable Certificates |  Lifetime Validity
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Training (23 Courses, 9+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Column Total Excel Template

EDUCBA

Download Column Total Excel Template

EDUCBA

डाउनलोड Column Total Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more