Help with formula
 

Hi,

here is my situation:

I have an excel spreadsheet to keep inventory of toner cartridges.

Cell A is the inventory of toner cartridges this number fluctuates according
to what's in stock and what has been added or subtracted. In Cell B I want to
keep a historic total of all of the toner cartridges that have ever been
added to inventory and NOT subtracted. Is there a formula that would add the
increases to stock but not the subtractions????

Any help would be much appreciated.

Thank you

Help with formula
 

Hello again.

I Have found this and it does just about what I want it to do:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Columns("C")) Is Nothing Then
If Target.Row < 1 Then
Cells(Target.Row, "D").Value = _
Cells(Target.Row, "D").Value + Target.Value
End If
End If
End Sub


The only adjustment I would like to make is if the number in the cell is
reduced then it would not affect the total in "D:"

Thanks


"klondike" wrote:

Hi,

here is my situation:

I have an excel spreadsheet to keep inventory of toner cartridges.

Cell A is the inventory of toner cartridges this number fluctuates according
to what's in stock and what has been added or subtracted. In Cell B I want to
keep a historic total of all of the toner cartridges that have ever been
added to inventory and NOT subtracted. Is there a formula that would add the
increases to stock but not the subtractions????

Any help would be much appreciated.

Thank you