Reference to cell directly to the left

Hello,

Is there any way to refer to a cell that is directly to the left of the current cell?

I need to create a Comma-Separated Value file with the Excel formula in the CSV file. Because of this, I do not know the current cell location, but want to do something like =(Cell directly to the left of me) + (Cell two cells to the left of me)

Is this possible?

Thanks.

Maybe someting like this:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Does that help?