individual sum of series in a column separated by blank cells

[pradhishnair]

Plz help..


Sample sheet attached...


https://docs.google.com/spreadsheet/ccc?key=0AgDJ-TLtQDaydHpDWjFLZFZIWFF6MVM1b2VaLUxHZWc

 

[Hui]

In E11: put

=IF(C12="",SUM($C$11:C11)-SUM($F10:F$11),"")

Then copy down

 

[pradhishnair]

Hi hui.. its a relief to find you at this tym...


the formula aint working for me coz for the first series it is giving me the right answer 48.2725 but for the second series instead of 58.36 it is giving me 48.2725 + 58.36 = 106.6275


Please help solve this...

 

[Hui]

Whoops

My mistake

In D11 it will be:

[pre]

=IF(C12="",ROUND(SUM($C$11:$C11)-SUM($D$10:$D10),2),"")

[/pre]
Then copy down

 

[pradhishnair]

Thnx hui.. works perfect for me...

 

[Montrey]

GJ Hui!