Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page How do I continue to take the sum of the last 50 non-zero numbers?
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-29-2016, 01:58 PM
radiotower radiotower is offline How do I continue to take the sum of the last 50 non-zero numbers? Windows 7 32bit How do I continue to take the sum of the last 50 non-zero numbers? Office 2016
Novice
How do I continue to take the sum of the last 50 non-zero numbers? 		 
Join Date: Dec 2016
Posts: 2
radiotower is on a distinguished road
Default How do I continue to take the sum of the last 50 non-zero numbers?
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
Attached Files
File Type: xlsx sample.xlsx (19.4 KB, 13 views)
Reply With Quote
  #2  
Old 12-29-2016, 11:55 PM
xor xor is offline How do I continue to take the sum of the last 50 non-zero numbers? Windows 10 How do I continue to take the sum of the last 50 non-zero numbers? Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Take a look at the attached.
Attached Files
File Type: xlsx SumLast50.xlsx (20.1 KB, 12 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


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
How do I continue to take the sum of the last 50 non-zero numbers? Trouble getting page numbers to continue from previous section MacPadana Word 4 08-06-2015 08:54 AM
How do I continue to take the sum of the last 50 non-zero numbers? Page numbers will not continue throughout document winningson Word 2 01-27-2013 06:34 AM
How do I continue to take the sum of the last 50 non-zero numbers? Bullets & Numbering - How to continue numbers in second slide? Learner7 PowerPoint 2 05-17-2010 05:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft