Pat19515Copper ContributorAug 27, 2023Excel Spreadsheet Calculator 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 l...Show More
HansVogelaarMVPAug 27, 2023Pat19515 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.
