One of the best features of spreadsheet applications like Numbers is its built-in functions and formulas. These handy little tools let you work with your numbers much easier. You can sum a column, get the maximum number in a row, average a group of cells, and more, without doing the calculations yourself.

While there are many built-in formulas, a handful of them are used most often. So, Apple makes these easily accessible in the Numbers application. They include sum, average, minimum, maximum, count, and product.

This tutorial shows you how to work with these common functions and formulas in Numbers on both Mac and iOS.

## Inserting formulas in Numbers on Mac

While the spreadsheet we’re using in our example is small, imagine if you have one with hundreds of columns or rows. This is when using those formulas for your calculations is most valuable.

Inserting the formula you want works the same way whether the values are in columns, rows, or a group of cells.

Start by selecting the cell where you want the formula and subsequent result displayed. Then, select Insert > Formula from the menu bar or the Insert button from the toolbar and pick the formula. When it pops into your spreadsheet, hit your Enter key.

Numbers will guess at which group of cells you want to apply the formula to; however, you can change this easily.

### Editing the formulas

Double-click the cell containing the formula you just inserted. A small pop-up will display showing you the formula and which cells it applies to. To change it, either drag the corners of the range of cells to those you want or click inside the pop-up and adjust the cells by typing in the labels. When you finish, click the checkmark in green.

## Getting a quick view of formulas

Maybe you want to get a view of one of the formulas without actually entering it into the spreadsheet as a cell. For instance, you might want to see the average of a column or the largest number in a group of cells.

Select the cells and at the bottom of the Numbers window, you’ll see each of those common formulas display automatically. And if there is one you want to add to the view, select the gear icon to the right and choose the function.