30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / How to Sum Random Cells in Excel
By Puneet Gogia (Microsoft MVP)

How to Sum Random Cells in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

To sum cells that aren’t next to each other, type =SUM( then hold Ctrl and click each cell — Excel inserts the commas for you — and close the bracket. The result is =SUM(A1,A5,B3,C7). You can mix single cells and ranges in the same formula: =SUM(A1:A5,C1,E3:E9). SUM accepts up to 255 separate arguments. If you only need the total once rather than in a cell, Ctrl-click the cells and read the Sum in the status bar at the bottom of the window.

If you want to sum random cells in Excel, you can simply use the SUM function and then select all those random cells with your mouse. In this way, the SUM function takes all the cells that you choose one by one, and when you hit Enter, it returns the sum of the values from those cells.

excel-sum-random-cells

You can use the following steps to sum random cells:

  1. Select the cell where you want to get the sum from all the random cells.
  2. After that, enter the SUM function in that cell.
  3. From here, press and hold the Ctrl key and select each random cell one by one for which you want to calculate the sum.
  4. In the end, enter the closing parenthesis and hit Enter to get the sum.

When you select each cell by pressing the Ctrl key, Excel automatically adds a comma between each cell reference, so you don’t need to add it manually. You end up with a formula like this one:

=SUM(A1,A3,C2,D5)

You can also type the cell references yourself, separated by commas, and mix single cells with ranges. SUM can take up to 255 arguments, and each argument can be a cell or a range:

=SUM(A1,A3,D5,B1:B10)

Sum Random Cells from Different Sheets

The same method works across sheets. After you type =SUM(, click a cell on one sheet, type a comma, go to the next sheet and click the next cell, and so on. Excel adds the sheet name to each reference:

=SUM(Sheet1!A1,Sheet2!B5,Sheet3!C3)

See the Sum without a Formula

If you only need to see the total and don’t need it in a cell, hold the Ctrl key and select the cells. The status bar at the bottom of the Excel window shows the Sum (along with the Average and Count) of the selected cells.

SUM vs the Plus Sign for Random Cells

You can also add random cells with the plus sign:

=A1+A3+C2+D5

But there’s a difference: SUM skips cells with text, while the plus sign gives a #VALUE! error if a cell has text. And when a cell has a number stored as text, SUM ignores it, but the plus sign converts it and adds it. So, if the two totals don’t match, check for numbers stored as text.

Frequently Asked Questions

Can I give a name to a group of random cells?

Yes. Select the cells with Ctrl, type a name in the Name Box (left of the formula bar), and press Enter. Then use the name inside SUM, like SUM(YourName), to sum them.

Why does my sum of random cells return 0?

The cells probably have numbers stored as text. SUM ignores them. Convert them to numbers (Data ➜ Text to Columns ➜ Finish), and the total updates.

Can I sum random cells with a condition?

SUMIF needs one range, so it can’t take a list of random cells. If the cells follow a pattern, like every other row, use SUMPRODUCT with MOD and ROW instead; otherwise, add one SUMIF for each part of the range.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment