=SUM(OFFSET(ACTIVECELL,-1,0,1,1)) ' Adds the value directly above
```
Explanation:
* ACTIVECELL: This refers to the current active cell.
* OFFSET(ACTIVECELL,-1,0,1,1): This function creates a range relative to the active cell:
* -1: Moves one row up (above the active cell).
* 0: Stays in the same column.
* 1: Specifies the height of the range (one row).
* 1: Specifies the width of the range (one column).
* SUM(): This function adds up all the values within the specified range (the cell directly above the active cell).
How to use it:
1. Select the cell where you want to display the sum.
2. Enter the formula `=SUM(OFFSET(ACTIVECELL,-1,0,1,1))` into the formula bar.
3. Press Enter.
To add values to the left of the active cell, modify the formula:
```excel
=SUM(OFFSET(ACTIVECELL,0,-1,1,1)) ' Adds the value directly to the left
```
This formula only changes the row offset to 0, and the column offset to -1, moving the range to the left instead of up.
Note:
* This formula assumes you have only one value to add. If you have multiple values, you'll need to adjust the range accordingly.
* If there's no value in the cell above/left of the active cell, the formula will return a `#VALUE!` error. You can add an IFERROR function to handle this:
```excel
=IFERROR(SUM(OFFSET(ACTIVECELL,-1,0,1,1)),0) ' Returns 0 if there's an error
```
