View Single Post
  #1   Report Post  
Jay
 
Posts: n/a
Default Add two cell values, retain it, and add another value

What I'd like to do is this. I have two (maybe 4 columns needed) columns, W3
= (4) and Z3 = (521). What I need to do is add a value to cell AH3 = (71) and
have cell Z3 increase by that number =(592) and have W3 increase by adding 1
to the value =(5) already in there. However, both the vlues in W3 and Z3 will
be retained until another value is added in column AH3, then, increase cell
Z3 by that value and cell W3 increase by 1 only each time Z3 increases.

Is this possible?