Arithmetic operator	Description	Example
:	Range operator Creates a reference to a range of cells. Placed between the first and last cells of the range Can be used to combine ranges of cells. In this case, it returns the range between the upper-left and lower-right cells, including those cells	=SUM(B2:C4) =SUM(A1:B1:C4:D4): The sum of all cells between A1 and D4, including those cells
Space	Intersection operator Creates a reference to the cells located at the intersection of the specified ranges	=SUM(A2:C4 B2:D4)
'sheetname'!	Creates a reference to a cell or range of cells on another sheet in the current document	=SUM(B2+'Sheet2'!В2) =SUM(B2:C4+'Sheet2'!B2:C4)
'sheetname n:sheetname m'!	Creates a reference to the same cell across multiple sheets in the current document (3D reference)	=SUM('January_2019:December_2019'!A1): The sum of the contents of cell A1 across all sheets in the specified range

When entering formulas, select the desired range of cells so you don't have to enter it manually.

Range operators:

operators_links_ranges

Intersection operators:

operators_links_intersection

Reference to cells on another sheet:

operators_links_sheeeet

Was this helpful?

Yes