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

arifrind's avatar
arifrind
Copper Contributor
Feb 25, 2023
Following.

Resources