Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Open the spreadsheet to edit in Microsoft Excel. Click the first empty cell after the last value in the row to sum. Click the "AutoSum" button in the top navigation menu.

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.

Type =SUM(cell range of first row, cell range of second row, cell range of third row, …) and hit Enter. Google Sheets will display the sum. Read next : How to remove Formula in Excel and keep Text .

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.

Fortunately, Excel enables you to freeze or hold stationary worksheet rows at a designated point while the rest of worksheet scrolls to the left or right. Open the Excel worksheet you want to edit.