If your cell is at the center of the column, you can use a combination of positional arguments. You can use positional arguments with the following functions:įor instance, we could calculate the average sales for the above example using the formula: For instance, if you have 20 or more columns in your table, you could use the formula =SUM(ABOVE) instead of referencing each cell inside the parenthesis. Positional arguments (ABOVE, BELOW, LEFT, RIGHT) can often make things simpler, especially if your table is relatively large.