Excel Spreadsheet Calculator

[Pat19515]

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?

[#2]

@Pat19515 

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.