#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Perhaps
Code:
=sum($c7:index(7:7,1,match(lookup(9.99e307,7:7),7:7,0)))
__________________
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 |
#3
|
|||
|
|||
What is the 9.99e307 value supposed to be?
|
#4
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving columns | plantzj | Word | 3 | 09-17-2011 10:30 AM |
Moving Tables | b0x4it | Word VBA | 9 | 05-20-2011 01:00 AM |
Moving comments | sollc | Excel | 3 | 04-13-2011 04:43 AM |
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 |