Is there anybody knowledgable with Excel formulas that can help me, if so I could use some help I have spent hours trying to to solve a condition to no avail.
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.
I have a ROI calculator that an old PA member created. Seems to work okay. You can reach me at " goforginatcomcastdotnet " and I can send a copy of it to you. Windows may reject it at first and you have to click "Run Anyway". But I was able to get it saved to my desktop.