You reference the sheets with a colon in between them, follow it with an exclamation mark and the cell reference. So your formula would be like this:
=SUM(Q1:Q4!B2)
F4
It will display either the current cell or a name of a named range if that range is selected. If the range selected is not named, then the name box show the cell reference of the active cell.
A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.
The active cell reference or name of a selected range. As you select cells, it indicates the amount of rows and columns being selected.
You create an absolute cell reference by placing a dollar sign ($) in front of both the column letter and the row number of the cell address. This is an internationally accepted convention for most spreadsheet software.
3-D Reference
You will see it in the Name Box. It will have the cell reference in it, or the name if a cell or range has been named. The header of the current row and current column will also be highlighted.
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
You can type in the dollars before the column and row in the cell reference, so A3 could become $A$3 in the formula. While you are typing a cell reference in a formula, pressing the F4 key will cycle through the relative, absolute and mixed cell references, so that is another way of doing it.
The name box shows the address of the current cell selected or the name of that cell if a special name has been given to it. It can also show the name of a range. You can type in a cell reference or a range name in the name box and it will bring you to that location. The name box appears to the left of the formula bar.
cell reference
A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.A6 is the cell reference for the cell in column A, row 6.