How can I insert a static calculation bar or row in a spreadsheet. I have up to 1500 rows of data but need to insert calculation such as totals and percentages after the first 100 rows. As I add additional rows of data to the top of the array I want the calculation bar to remain faithful only to the first 100 rows.
