Note:
I already have a routine that will use a loop to determine Cumulative Sales.
My goal here is to use an Evaluate in cell formulas to obtain the
same results:
There are 12 ROWS related to Columns A B C
Column A is TIME with values 1 to 12
Column B is Sales with these Values
{10;25;100;250;600;1200;2000;3800;4900;2800;2100;800}
Column C is to be Cumulative Sales
which I cannot get to work
Below is code that fills up Columns A and B and FAILED code for Column C
The ONLY SOLUTION I am after is an Evaluate solution and this ASSUMES
that Evaluate can do this. I could be WRONG.
Thanks in advance if anyone goes after this.
John
Bookmarks