Forum Discussion
Carlos Monssen
Sep 21, 2017Copper Contributor
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 i...
SergeiBaklan
Sep 22, 2017Diamond Contributor
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.