Informatics for the public health workforce
Use of parentheses
The use of parentheses, within the function, indicates all the information or data that will be used or acted upon. Pressing the Enter or Return key at the end of a function will automatically add the closing parentheses.
A range of cells can be specified by using a colon between the first cell name and the last cell name.
For example, using the SUM Function: =SUM(C3:C10).
Note the use of parentheses around the cell range. Excel also shows a help box of how the function is formatted. In this case, the SUM Function expects a series of numbers that can be represented as a range.