Reset a cell to 0 when a conditional formula is met in another cell

[Steve Cohen]

I don't know if this can be done or not or if it needs to be done in Visual
Basic, but I need some help.

I am looking for a formula that will reset a cell to 0 when a conditional
formula is met in another cell.

When the conditional formula in column E
"=Tradewinds_Activity>=Tradewinds_Bonus*5" is met the cell turns to white.
This part is easy and I have done already, but what I would like to add is
when the condition of column E is met it resets the values in columns D & E
to 0, so I can start counting the activity again.

The current formula in D
[SUM(SUMIF(Tradewinds!F:F,{"*Win*","*Loss*","*Push*","*Void*","*Bet*"},Trade
winds!A:A))] looks in column F of the "Tradewinds" worksheet for Win, Loss,
Push, Bet, or Void and if it finds any of them adds the amount that is in
the corresponding row of column A in the "Tradewinds" worksheet to the
Activity or column D on the "Trans_type" worksheet.

The formula in column E
[=SUM(SUMIF(Tradewinds!F:F,{"*Deposit*","*Bonus*"},Tradewinds!A:A))] is
basically the same, but looks for Deposit or Bonus in Column F of the
"Tradewinds" worksheet and the adds the amount that is in the corresponding
row of column A of the "Tradewinds" worksheet to the Rollover or column E on
the "Trans_type" worksheet.

This is kind of difficult to explain, if you need any more information, just
ask.

Thanks

Steve

 

[Don Guillett]

Steve,
Please do NOT post to more than one group. All that would help read all or
most.