0
A colon is used for a range, by putting it between two cell references. So if you want to refer to the range from cell A3 to cell C9, it would be A3:C9 which could be then used in a function:
=SUM(A3:C9)
=AVERAGE(A3:C9)
=MAX(A3:C9)
Wiki User
∙ 9y ago
Wiki User
∙ 9y agoIn a SUM function or in any function that you are specifying a range, a colon between two cell references will be used. So to sum the range from cells A2 to A20, you would do it like this:
=SUM(A2:A20)
Wiki User
∙ 13y agoThe colon (:). To show the range of A1 through A12, use A1:A12.
Add your answer:
Earn +20 pts
What is the symbol used between two code numbers to indicate that a range is available?
The symbol used between two code numbers to indicate that a range is available is a
A colon between two cell references indicates a range of cells that includes?
the entire worksheet
What does a colon between two cells references indicates a range of cells including?
all cells between the two cells
Which punctuation mark between codes in the index of the cpt manual indicates a range of codes available?
hyphen
Which punctuation mark between codes in the index of the cpt manual indicates a range of codes is available?
hyphen
What is placed between a starting value and ending value defining a range?
A symbol such as a comma, a colon or a hyphen.
What is the symbol for Range Resources Corporation in the NYSE?
The symbol for Range Resources Corporation in the NYSE is: RRC.
What is frequency range of airtel SIM card?
The SIM card doesn't have a frequency range as such, that comes from the phone the card is inserted into.
In which range does Borg's of perceived exertion recommend you exercise?
In the green range, which indicates a medium level of exertion
What do the Dun and Bradstreet rating numbers ER2 mean?
ER stands for "Employee Range." The number indicates a range of the number of employees in a company. ER2, for example, indicates 500 to 999 employees.
In which range does Borg's scale of perceived exertion recommended you exercise?
In the green range, which indicates a medium level of exertion
Why does Values are outside the normal range indicate disease?
Values outside of the normal range always indicates the presence of disease?
