Each day, I put a large number in one column and 0 in the other. I need to be able to take the sum of the last 50 non-zero numbers for each column. The cell after that should take the sum of the 2nd-51st numbers (excluding 0s), then the next cell should take the sum of the 3rd-52nd numbers (excluding 0s), etc.
My issue is, when I move to the 51st non-zero number in a column, I do not know how to exclude the 1st non-zero number in the same column.
Cross posts:
http://www.mrexcel.com/forum/excel-q...o-numbers.html
http://www.excelforum.com/showthread.php?t=1168070