In addition to using the AutoSum button for the above functions that we looked at in the last post, you can also type in these functions manually, directly into the desired cell.
The format is:
=Function name, cell range surround by parenthesis.
For example, if you wanted to find the Average from the cell range B3 to B8, you would enter the following formula in cell B9:
=AVERAGE(B3:B8)
To include non-contiguous cells in the formula, separate each cell or cell range by a comma. For example, if you wanted to find the Average for cells B3:B8, D3:D8 and cell F5, the formula would read:
=AVERAGE(B3:B8, D3:D8, F5)
Similar Posts:
- None Found
