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!!!!!!

Amount	Amount	Result
100	1/01/2012	100
120
200
500	10/01/2012	820
150
230
300
600
100	15/01/2012	1380

<tbody>
</tbody>

 

[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!!!!!!

Amount	Amount	Result
100	1/01/2012	100
120
200
500	10/01/2012	820
150
230
300
600
100	15/01/2012	1380

<tbody>
</tbody>

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!!!!!!

Amount	Amount	Result
100	1/01/2012	100
120
200
500	10/01/2012	820
150
230
300
600
100	15/01/2012	1380

<TBODY>
</TBODY>

This formula entered in C2 and copied down:

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