Question

How can we add a range of cells?

Answer 1

Select the range of cells, and the blank row below the range, and the blank cells in the column to the right (cells A1:D5 in the example below)Click the AutoSum button on the Ribbon's Home tab. A SUM formula will be automatically entered for each Total.