Assigning values and summing results into specific cell

[tbakas2]

Thank you in advance for the help. I'm using Microsoft XP, I'm in the VBA editor in Excel. I'm trying to write code that will assign a positive or negative value based upon what the adjacent cell reads. Example:

Buy 70
Sell 45
Sell 30
Sell 25
Buy 65

My goal is to have code that will assign negative values to 'Sell' values and positive values to 'Buy" values. Additionally, I would like to have the net result posted into a specific cell. I'm very new to this, please let me know if you need more information.

[ADezii]

If you are only going to have a limited amount of data, and your only options will be either Sell or Buy, you can set the Formulas in the individual Cells. If Column A contains only Sell or Buy, and Column B will contain the numeric values:

=IF(A1="Sell",45,-45)          'place in Cell(B1)

For simple summarizing, use the Sum() Function. The following Formula placed in any Cell will Sum the values from B1 to B25 inclusive:

=SUM(B1:B25)