When you're staring at a massive spreadsheet, counting cells manually isn't just tedious—it's a recipe for mistakes.

A named range simplifies referencing cells in your formulas. Instead of having to look at your spreadsheet to find the cells and write a formula like =SUM(B1:B10), you can simply use =SUM(TotalSales).

A formula is an expression that operates on values in a range of cells in Excel. Using formulas, you can perform calculations and data analysis on the contents of the cells.

Select the range where you want to identify formula cells. This can be the entire sheet or a simple data range. In the case of the example sheet, you might select cells B3:E11.

When Excel displays the various cell/range dialog boxes, ... For example, the actual formula in cell E2 is =SUM(C2*D2); but all you see is the answer, which is $164.25.

You can subtract the range of cells in Excel by using the minus (-) sign or by using the SUM function. Let’s say, you want to subtract the cells B2 to B10 from the cell B1, then the formula ...

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 .

When you link a cell in Excel to a cell from another worksheet, ... you can use an array function, which lets you link a range of cells using one formula.

Select the cell range to paste the cells into with the Range function and Select method, making sure the range selected represents the destination cells. Paste the cell range with the statement ...

The formula is =B2:B10-F2:E10 or =B2:B10F2#. Excel uses the pound sign (#) to reference a spilled range, and that’s what will appear if you build the formula by selecting the cells F2:F10 , as shown ...

2. From the Formulas tab, click Define Name.. 3. Notice that Excel has already entered the column/field name of the range you highlighted (even though that cell was not included in your range).