Sum cells none direct reference

[jakobt]

Want to insert a sum formula:
Want to sum the 2 cells:
The cell referenced 2 columns above and the cell referenced 3 columns to the right.

 

[Joe4]

Let's say that you want to put the sum in cell A10, and you want to add A8 to D10.
You could do this with only using the reference to the cell the formula is going in (A10), like this:

=SUM(OFFSET(A10,-2,0),OFFSET(A10,0,3))