Excel Spreadsheet Calculator

Copper Contributor

I have created individual spreadsheets for certain finance which are calculating fine but my SUMMARY spreadsheet has stopped calculating on the last 3 rows. I am presuming it's how I have added the lines, can anyone tell me how to add lines properly to keep the calculator working?

1 Reply


You might convert the source data to a table, and refer to the table in your formulas.

Alternatively, define dynamic named ranges (see here ) and use those in your formulas.