How to create a cumulative column based upon another column

**maani** · 07-24-2009, 08:05 AM

Hello,

I have a model built that calculates the daily Profit and loss ('Data for Pivot' tab, column M). I would like to calculate the cumulative profit and loss and am having a difficult time doing this with a simple formula. The Daily P/L column is empty (#NA value is in the cells) up until cell C138 as there is no data before that (which is the way it is supposed to be). However, once data has begun to be populated the daily profit and loss is shown (in this case from M138 onwards). The issue I am having is that I cannot seem to be able to create a formula that will capture the cumulative P/L. My desired result is evident in cells N179 onwards, as it simply captures the cumulative p/l. However, this only works if I change the formula once data is populated (in this case cell N177 is where i put in a new formula; the previous formula can be seen in cells N3-N176). If I attempt to put in the formula that is in cell N177 for all of the cells in column N, it gives me an error. Thus, I think that this may need to be programmed via VBA, but I have not been successful in doing this. The issue is that the data population in this model begins on different cells based on the different inputs that I put in ('Mov_Avg_Chart' tab, cells c6 and c8). Thus, I can't hard-code a formula based on a particular cell. If anyone can help me with this, I'd greatly appreciate it, as I've just spent the better part of a day trying to figure this out and cannot.

Thanks,

Maanihttp://www.4shared.com/file/12029727...Version_4.html

**jrussell** · 07-24-2009, 08:51 AM

Oh joy: "Websense blocks personal network storage and backup." Might want to put that file somewhere else.

**maani** · 07-24-2009, 09:02 AM

Is that the error you are receiving when trying to download the file? I tried to download it from the link and had no problem downloading it. I do not know of any other sites to post the link on. Do you know of any sites you recommend?

**jrussell** · 07-24-2009, 09:09 AM

Sorry, I should have been more helpful. You can do it as an attachment on your post, like this. Hit the paperclip.

**maani** · 07-24-2009, 09:16 AM

No worries. I can't attach the file to my post even once its zipped - it keeps saying upload of file failed even though its 6MB, which is under the maximum file zip file size. Do you know of any file sharing websites I could post it on that won't get caught up in your Webanese error? Sorry again about the inconvenience.

**jrussell** · 07-24-2009, 09:40 AM

I don't know of any sites that will work. Can you use your own domain if you have one, or give us a version with less data?

**maani** · 07-24-2009, 10:44 AM

I tried the link through various other computers and it works on all of them. I cut down the file size all the way to 2mb and it still won't attach, even as a zip file. Could I email it to you?

The link is http://www.4shared.com/file/12029727...Version_4.html

**maani** · 07-24-2009, 10:55 AM

I have re-posted it with a much smaller file size; could you see if this works?

http://www.4shared.com/file/12033667...Version_5.html

**jrussell** · 07-24-2009, 11:01 AM

I have Websense on my network here at work, I can't get to that site at all. If you can make the file 1 mb or less, you can post it as an attachment. Don't email it to me, I'm not making any guarantees about having time to work on it or even knowing how to solve the problem. The point is to make the file available to everybody. Ask a mod how to do that if you need to.