Sum a range of cells while adjacent cells are blank and then stop when a non blank cell exists.

[rob_sheeds]

Hi,
I need to sum a range of cells while a range of adjacent cells are blank. I want to sum them until I hit a non blank cell.
Though of using offset but all I could do would be ignore blanks. I need to sum range to stop when it hits a blank.
Eg.
So basically in the last right cell for example I want to sum the amount column from 15/01/2012 up until but not including the 10/01/2012 or when it hits the first non-blank.....
Thanks in advance!!!!!!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Amount
[/TD]
[TD]Amount
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]1/01/2012
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]120
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500
[/TD]
[TD]10/01/2012
[/TD]
[TD]820
[/TD]
[/TR]
[TR]
[TD]150
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]230
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]15/01/2012
[/TD]
[TD]1380
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Hi,
I need to sum a range of cells while a range of adjacent cells are blank. I want to sum them until I hit a non blank cell.
Though of using offset but all I could do would be ignore blanks. I need to sum range to stop when it hits a blank.
Eg.
So basically in the last right cell for example I want to sum the amount column from 15/01/2012 up until but not including the 10/01/2012 or when it hits the first non-blank.....
Thanks in advance!!!!!!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Amount
[/TD]
[TD]Amount
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]1/01/2012
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]120
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500
[/TD]
[TD]10/01/2012
[/TD]
[TD]820
[/TD]
[/TR]
[TR]
[TD]150
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]230
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]15/01/2012
[/TD]
[TD]1380
[/TD]
[/TR]
</tbody>[/TABLE]

C2, copied down:

=IF($B2="","",SUM($A$1:A2)-SUM($C$1:C1))

 

[Teethless mama]

Excel Workbook
	A	B	C
1	Amount	Amount	Result
2	100	1/1/2012	100
3	120
4	200
5	500	1/10/2012	820
6	150
7	230
8	300
9	600
10	100	1/15/2012	1380
Sheet1

 

[T. Valko]

Hi,
I need to sum a range of cells while a range of adjacent cells are blank. I want to sum them until I hit a non blank cell.
Though of using offset but all I could do would be ignore blanks. I need to sum range to stop when it hits a blank.
Eg.
So basically in the last right cell for example I want to sum the amount column from 15/01/2012 up until but not including the 10/01/2012 or when it hits the first non-blank.....
Thanks in advance!!!!!!

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Amount
[/TD]
[TD]Amount
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]1/01/2012
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]120
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]200
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500
[/TD]
[TD]10/01/2012
[/TD]
[TD]820
[/TD]
[/TR]
[TR]
[TD]150
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]230
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]600
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100
[/TD]
[TD]15/01/2012
[/TD]
[TD]1380
[/TD]
[/TR]
</TBODY>[/TABLE]

This formula entered in C2 and copied down:

=IF(B2="","",SUM(A$2:A2)-SUM(C$1:C1))