some errors in my last post that I just noticed: The formula for cell A3 is missing a ) The formula for B1 should be: if(reset=0,0,(if A3=1,A1,B1)) - it should refer to itself.
These are the sort of things that are very hard to discover on one's own without some external prodding. I've found many valuable tidbits on the MrExcel website, including the following : http://www.elitetrader.com/vb/showthread.php?s=&postid=403901#post403901 Once again, good stuff.
HI, exel accumulator works but ther is another problem: In cell A1 i receive real time data that chenge periodically and that data accumulate in A2. For example: if in A1 we have 3 numbers (1,2,3) it is correct in A2 to see sum=6 but when A1 shows first number and waiting for second, A2 accumulate first number many times until it is waiting second number -> (1+1+1+1+1 .... +2) and that make total sum in A2 incorrect. How i can fix that? thx a lot.
Kamburov, it sounds like you are not terminating the loop. PM me and send me your excel file and i will fix it for you.