Excel is great for calculations with formulas. But if you find your head spinning trying to remember how they work, we have the ultimate Excel hack for you. This video shows you how to do super-fast sums without formulas.
Calculate Totals in Excel Without Writing Formulas
Need to quickly add up numbers in Excel without typing =SUM(...) every time? Fortunately, Excel offers several built-in tools that let you calculate totals in seconds—no formulas required.
Whether you’re checking figures, analysing data, or working with large spreadsheets, these shortcuts can save you a surprising amount of time.
1. Use the AutoSum Shortcut (Alt + =)
The fastest way to insert a total is with Excel’s AutoSum shortcut. Excel automatically detects the range of numbers and creates the formula for you.
To total a column:
- Click the cell directly below your list of numbers.
- Press Alt + =.
- Press Enter to accept the suggested calculation.
To total a row:
- Click the cell immediately to the right of the numbers.
- Press Alt + =.
- Press Enter to complete the calculation.
In just a couple of keystrokes, Excel inserts the correct SUM formula for you.
2. View Instant Totals in the Status Bar
If you simply want to know the total without adding anything to your worksheet, the Status Bar is the quickest option.
- Highlight the cells you want to calculate.
- Look at the bottom-right corner of the Excel window.
Excel instantly displays useful statistics, including:
- Sum
- Average
- Count
This is perfect for quick calculations when you don’t need to save the result in your spreadsheet.
3. Add Automatic Totals with Excel Tables
If you regularly work with large datasets, converting your data into an Excel Table makes calculating totals effortless.
- Click anywhere within your data.
- Press Ctrl + T and press Enter to create a table.
- Open the Table Design (or Design) tab.
- Tick Total Row.
A new row appears at the bottom of your table with drop-down menus that let you choose calculations such as Sum, Average, Count, and more for each column.
Work Smarter in Excel
You don’t always need to write formulas to perform calculations in Excel. Features like AutoSum, the Status Bar, and Excel Tables help you calculate totals in seconds, making them ideal for checking figures, analysing data, and speeding up everyday tasks.
Learning these simple shortcuts can make working with spreadsheets faster, easier, and far more efficient.
We regularly update the Tech Tips with new articles and advice from the IT West team so be sure to check back for the latest technical tips, tricks and guidance from our team of business IT experts.