Forum Discussion

Pat19515's avatar
Pat19515
Copper Contributor
Aug 27, 2023

Excel 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 lines, can anyone tell me how to add lines properly to keep the calculator working?

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 27, 2023

    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.

Resources