If you want to count 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.
You can use the following steps to sum random cells:
- Select the cell where you want to get the sum from all the random cells.
- After that, enter the SUM function in that cell.
- From here, press and hold the Ctrl key and select each random cell one by one for which you want to calculate the sum.
- In the end, enter the closing parentheses and hit enter to 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.