Hi there guys, seems a very helpful forum this!
http://s130.photobucket.com/albums/p275/foxystoat/?action=view¤t=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.
Many thanks in advance
http://s130.photobucket.com/albums/p275/foxystoat/?action=view¤t=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.
Many thanks in advance
Last edited: