Tips for quickly calculating Totals in Excel
Did you know that you can sum a column in Excel with one click?!
As an office worker, time is a precious thing. You need results fast!Since time is of the essence, we put together this guide on the 5 fastest ways to calculate Totals in Excel
Calculate totals in Excel with one click on the status bar
If you need to total an entire column, the fastest way to total a column is to click the letter of the column containing the numbers you want to total. That's it!.
The results are displayed below on the Excel Status Bar. The status bar will display Average, Count, and Total.
Really fast, this method allows neither copying nor displaying of digits.
This method also applies to rows. Click on a row to sum the entered numbers in a row.
But what if you want to copy numbers or display them as digits? Don't worry, we have some more tricks to show you!
How to calculate the total number of columns in Excel with AutoSum
If you want to sum a column in Excel and keep the results in your table, you can use the AutoSum function . It will automatically add the numbers and will display the total in the cell you select.
- To avoid any additional actions like selecting a range, click the first empty cell below the column you need to sum.
- Navigate to the Home -> Editing tab and click the AutoSum button .
- You will see Excel automatically add the = SUM function and select the range with your numbers.
- Just press Enter on your keyboard to see the total number of columns in Excel.
This method is fast and allows you to automatically get and keep the aggregated results in your table.
Enter the SUM function manually to sum a column in Excel
You can also enter the SUM function manually. Why do you need this? Sum only some cells in a column, or to specify an address for a large range instead of selecting it manually.
- Click the cell in your table where you want to see the total of the selected cells.
- Type
=sum(
in this selected cell.
- Now select the range with the numbers you want to sum and press Enter on your keyboard.
Tips. You can enter the range address manually like
=sum(B1:B2000)
. It is helpful if you have a large range to calculate.
That's it! You will see the column aggregated. The total will appear in the correct cell.
This option is really useful if you have a large column to sum in Excel and don't want to highlight the range. However, you still need to enter the function manually.
Note: The SUM function will work even with values from hidden and filtered rows . If you just want to sum visible cells, read on and learn how to do it.
Use Subtotals in Excel to sum only filtered cells
This feature is perfect for summing only visible cells. As a rule, these are filtered or hidden cells.
- First, filter your table. Click any cell in your data, go to the Data tab, and click the Filter icon .
- You will see arrows appear in the column headers. Click the arrow next to the exact title to narrow the data.
- Uncheck Select All and highlight only the value(s) to filter by. Click OK to see the results.
- Select the range of numbers to sum and click AutoSum in the Home tab.
Voila! Only filtered cells in the column are aggregated.
If you want to sum the visible cells but don't need to paste the total into your table, you can select the range and see the total of the selected cells on the Excel Status bar . Or you can go ahead and see an option to sum only filtered cells.
Convert your data into an Excel table to get totals for the column
If you frequently need to sum columns, you can convert your spreadsheet to an Excel Table . This will simplify summing columns and rows and doing many other things with your lists.
- Press Ctrl + T on your keyboard to format the cell range as an Excel Table .
- You will see a new Design tab appear. Navigate to this tab and check the Row Total checkbox .
- A new row will be added to the bottom of your table. To make sure you get the total, select the number in the new row and click the little down arrow next to it. Select the Sum option from the list.
Using this option allows you to easily display totals for each column. You can see the total as well as many other functions such as Average, Min and Max.
This feature only adds visible (filtered) cells. If you need to calculate all the data, please use the instructions from How to Sum Columns in Excel with AutoSum and Manually Enter the SUM Function to Sum Columns .
Using Autosum Excel – ALT shortcut = quick sum
The Autosum Excel shortcut is very simple – just type two keys:
ALT =
Step 1: place the cursor below the column of numbers you want to sum (or to the left of the row of numbers you want to sum).
Step 2: Hold down the Alt key and then press the equal sign = while still holding Alt.
Step 3: Press Enter.
Example of Excel Autosum function
Here are two screenshots of the Autosum Excel shortcut in action.
The first example shows the Autosum formula being used on a vertical number series , and the second example shows the formula being used on a horizontal number series.
It is important to place your cursor in the correct position before pressing ' Alt = '.
See an example Excel screenshot below:
Whether you need to sum an entire column in Excel or sum only visible cells, in this article I have covered all possible solutions. Choose an option that will work for your table: check the sum on the Excel Status bar, use the SUM or SUBTOTAL function, check the AutoSum function, or format your data as a Table.
If you have any questions or difficulties, don't hesitate to leave a comment. Be happy and excel in Excel!
You should read it
- Steps to lock columns in Excel
- How to delete, add columns in Excel
- How to convert columns into rows and rows into columns in Excel
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to combine 2 columns Full name in Excel does not lose content
- How to keep Excel and Excel columns fixed?
- Instructions for separating column content in Excel
May be interested
- MS Excel 2007 - Lesson 6: Calculation in Excelexcel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel 2007.
- How to draw a table in Excelhow to draw a table in excel. excel spreadsheets are great tools for calculating numbers. in this article, you can help excel table guys as quickly as possible.
- How to calculate the number of days in Excel - Functions, formulas for calculating the number of days in Excelhow to calculate the number of days in excel - functions, formulas for calculating the number of days in excel. in the process of processing data in excel, you will certainly encounter many cases that need to calculate the number of days such as the number of days guests stay, the number of days to perform work ... it will be difficult if the
- Test Microsoft Excel P16when using an application regularly, you will often get used to it and handle it faster. are you confident enough about your ability to use excel? try a little test to measure your excel proficiency!
- PRODUCT function in Excel, syntax, usagethe product function in excel helps to quickly calculate the product of multiple values, instead of having to enter each number with a multiplication sign. this function is useful in calculating financial, scientific and accounting data.
- SUM function in Excel: How to use SUM to calculate totals in Excel - SUM function in Excelthe sum function in excel is quite commonly used. below are details on how to calculate the sum function and related issues in microsoft excel.
- Calculation of age in Excelto calculate age in excel, we can use these two functions as year or datedif functions.
- Test Microsoft Excel P13in this article, network administrators will continue to learn about excel software through extremely interesting multiple-choice questions below. try to see how many questions you will make.
- Practice exercises on payroll in Excelthe following article gives detailed instructions to you practice exercises on payroll in excel. for example, there is the following data table: calculating employee's gross salary, calculating the maximum value of salary, advance and remaining, average and minimum value
- Microsoft Excel Test P11the excel 2010 interface changes very little compared to excel 2007 with the rearrangement of some on-screen components and the return of the file pane instead of the confusing office button. here, the network administrator will join readers to learn about new features in excel 2010 through the multiple choice questions below.