Thread: SUMIF or IF without returning to false or zero value

I have some trigger cells (0 or 1) based on time of day. I would like to calculate some other cells and place the resulting value in the cell. This obviously works with a SUMIF or IF when TRUE, but as soon as the trigger goes false the cell value returns to zero of FALSE. I need the resulting value to remain what it was in the true state and nothing to change when it goes false (only update the cell on a true condition). I would like to do this with a function instead of a macro since I already have several other macros running and I need to do this with several cells.

For example: cell A1 becomes 1. When A1 is TRUE or 1, the sum of A2 and A3 is placed in B1. When A1 returns to FALSE or 0, the B1 cell remains the same (nothing changes on a true to false).

Hi.. If you are wanting to use function instead of macro, as far as I can see, you can only do that if you change the workbook calculation from automatic to manual.
Cheers

I am trying to copy a cell value which is an external reference. This value increases over a 24 hour period. I want to capture the value at each hour and save it in another cell. So at the end of 24 hours I have 24 cells with the value at each hour.