Excel formulas I want to calculate ROI I know the formula on how to do this, the only thing that I now need is the $net, I have the components for accumulating the $, but what I need is the ongoing sum for the $ won.
Example cells (A1:A2000) contain a "W" if I won and next to that cell (A2:A2000) is the amount that I won, what I need is another dedicated cell to contain the ongoing total $sum that I have won.