Formula help please

[foxystoat]

Hi there guys, using Excel 2010 here....

http://s130.photobucket.com/albums/p275/foxystoat/?action=view&current=Excel.jpg

If I had varying amounts of data (see picture in above link - tried to paste image direct to this page but website wouldn't let me) and wanted to put in sub totals of each group of data (as per the red boxes), what way can I best do this? Obviously, I can't copy the formula and paste all the way down my very lengthy spreadsheet.

Any quick fixes to sort this out?

Cheers

 

[foxystoat]

Sorry, link should be http://i130.photobucket.com/albums/p275/foxystoat/Excel.jpg

 

[Roj47]

There will be a better way soon, but for now. Start in Cell A2

Column A : Insert your figures complete with gaps
Column B : =IF(A2>0,1,0)
Column C : =IF(B2=1,A2+C1,0)
Column D : =IF(A2="",C1,"")

Hide Columns B & C and copy formulae down.

 

[zeeeeks]

Sorry, link should be http://i130.photobucket.com/albums/p275/foxystoat/Excel.jpg

Is there another column that shows whats seperating the data?

 

[snoopyhr]

assuming: your data is in column C as shown by gap, place this formula in column D adjacent to first data (C10=1.93) in D10 place this formula:

=IF(C10=0,SUM($C9:C$10),0)-IF(C10=0,SUM($D9:D$10),0)

Format 0's to show as blank and copy down.

 

[foxystoat]

Roj47, I'm not quite sure how that formula calculates it all, but it sure works, and will save me a lot of time going forwards!

Many thanks, that is truly brilliant

 

[snoopyhr]

click by mistake