Forum Discussion

Saad_Khalil's avatar
Saad_Khalil
Copper Contributor
Feb 22, 2023
Solved

Conditional SUM

Hello all,   If anyone could clear my doubt. I want my table to add its values automatically after every hour. How can i do this in excel.    
excel
  • tauqeeracma's avatar
    tauqeeracma
    Feb 25, 2023

    Hi Saad_Khalil 

     

    In that case, I think the best option is to put the calculation option as "Manual" and uncheck the 'Recalculate workbook before saving' option as mentioned below:

     

    Update your table as you like, and change the values. The total of the table will remain the same.


    Whenever you want to refresh your table, simply press the F9 key.

     

    Please ensure that the option is set again as "Automatic" for other excel workbooks.

     

    Thanks

    Tauqeer

Saad_Khalil's avatar
Saad_Khalil
Copper Contributor
Feb 25, 2023

HI  tauqeeracma,

 

Firstly I would like to thank you for replying. Brother I get what you have done here, but not quite what I was looking for. I will explain the scenario below.

 

Scenario:

I have some data in a table and at the end of the table there is a cell for the total of the values in the table. Normally when we change any value in the table the total is re-calculated right away. What I want is that the total is re-calculated after an interval of an hour, irrespectively if we change a value in the table or not.

 

I hope I was able to explain my scenario.

 

 

Regards 

Saad

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Feb 25, 2023

Hi Saad_Khalil 

 

In that case, I think the best option is to put the calculation option as "Manual" and uncheck the 'Recalculate workbook before saving' option as mentioned below:

 

Update your table as you like, and change the values. The total of the table will remain the same.


Whenever you want to refresh your table, simply press the F9 key.

 

Please ensure that the option is set again as "Automatic" for other excel workbooks.

 

Thanks

Tauqeer

Resources