How do I continue to take the sum of the last 50 non-zero numbers?

radiotower · #1 12-29-2016, 01:58 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't continue numbering in the previous format	stonecold	Word	2	09-26-2016 04:55 AM
I want to continue a spreadsheet I did not create	jgrubby	Excel	2	10-01-2015 04:15 PM
Trouble getting page numbers to continue from previous section	MacPadana	Word	4	08-06-2015 08:54 AM
Page numbers will not continue throughout document	winningson	Word	2	01-27-2013 06:34 AM
Bullets & Numbering - How to continue numbers in second slide?	Learner7	PowerPoint	2	05-17-2010 05:05 AM