Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2012, 08:35 AM
dmrj78 dmrj78 is offline Moving sum Windows XP Moving sum Office 2003
Novice
Moving sum
 
Join Date: Oct 2012
Posts: 2
dmrj78 is on a distinguished road
Default Moving sum

Is there a formula out there that will allow me to sum a range in a row and then let me move that range?
For example I want to sum C7:H7. Then I would want to sum C8:I8 and so forth, but I don't want to have to d0 the sum formula for every row. Column C would stay constant, but I need the next column to continue moving.


Any help would be great! I am working on a lot of waterfall charts if that helps. This would be a huge time saver if anyonve knows how to do this.
Reply With Quote
  #2  
Old 10-29-2012, 09:57 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Moving sum Windows 7 64bit Moving sum Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps
Code:
=sum($c7:index(7:7,1,match(lookup(9.99e307,7:7),7:7,0)))
and pull down as needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 10-29-2012, 11:02 AM
dmrj78 dmrj78 is offline Moving sum Windows XP Moving sum Office 2003
Novice
Moving sum
 
Join Date: Oct 2012
Posts: 2
dmrj78 is on a distinguished road
Default

What is the 9.99e307 value supposed to be?
Reply With Quote
  #4  
Old 10-29-2012, 12:34 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Moving sum Windows 7 64bit Moving sum Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

9,99e307 is the largest value that XL can handle. It is written in scientific notation
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving sum Moving columns plantzj Word 3 09-17-2011 10:30 AM
Moving sum Moving Tables b0x4it Word VBA 9 05-20-2011 01:00 AM
Moving sum Moving comments sollc Excel 3 04-13-2011 04:43 AM
Moving sum Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM
Moving Items windsurfer Outlook 0 12-06-2005 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:19 PM.


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