title: Excel, auto refresh consolidation statistics
body: <p>What if I have list of activities and every day I fix how many hours were spent reading, writing, etc. </p>
  
  <p>And I want to see summary by Date field, for example 17 July I was walking for 4 hours and reading for 7 (total is <strong>11</strong>):</p>
  
  <p><a href="https://i.stack.imgur.com/AN3TD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AN3TD.png" alt="enter image description here"></a></p>
  
  <p>I added consolidation by left column, like described in this video:
  <a href="https://www.youtube.com/watch?v=IGaq_biQ1B8" rel="nofollow noreferrer">https://www.youtube.com/watch?v=IGaq_biQ1B8</a></p>
  
  <p>But how to make this statistics aut-updating(later I'll add other records but statistics ends for 20 July)?</p>