Forum Discussion
Excel Count Function - Need to include result of a formula in the cells counted
i have this formula which i want to go thru 23 cells and only move 8 values > zero. I am trying to move the value of cell to another cell if it is greater than zero based on the number of times it is done.
IF(AND($AY2< 9,$Y2>0),+$Y2,0) if this stament is true i would like to add 1 to $AY2 OR SOME COUNT OR INDEX so it is dynamic based on a true result
1 Reply
Hi Carlos,
You try to update the value in $AY2 based on what you have in it currently. That doesn't work with formulas, they don't remember the history. If only with VBA script.
