For instance, you could sum up the values above and below a specific cell using the following formula: =SUM(ABOVE,BELOW) 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: =AVERAGE(ABOVE) 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.
0 kommentar(er)
