0

What if I have list of activities and every day I fix how many hours were spent reading, writing, etc.

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 11):

enter image description here

I added consolidation by left column, like described in this video: https://www.youtube.com/watch?v=IGaq_biQ1B8

But how to make this statistics aut-updating(later I'll add other records but statistics ends for 20 July)?

Gennady G
  • 996
  • 2
  • 11
  • 28
  • What do you mean? You want to know how to have your column G auto-update when a value in "Hours" changes? Say you change the walking on 17 July to 6 hours. You want the "Total Hours" for that day to update? – BruceWayne Aug 14 '17 at 22:36
  • 1
    Use a pivot table. – Luke_0 Aug 15 '17 at 02:59
  • Hi! Sorry english not native. No, mean if I add new records for example for "23-July-17", I want to see new consolidation records too (now as I understand - I need to recalculate it every time for new rows..) http://imgur.com/a/ma2rn – Gennady G Aug 15 '17 at 09:43
  • 1
    The dynamic version is a bit complicated with array formula https://exceljet.net/formula/extract-unique-items-from-a-list, and SUMPRODUCT to get the sum of each item. VBA Macro to refresh the Pivot Table on Worksheet Change event can be easier http://www.eonesolutions.com/blog-post/tech-tues-automatically-refreshing-pivot-tables-excel-refreshable-reports/ – Slai Aug 20 '17 at 18:54
  • Thank You @Slai! – Gennady G Aug 21 '17 at 11:38

1 Answers1

0

Ok, so as I understand I can create a Pivot Table near. It does not recalculate values "on-the-fly", but I can press "Refresh all" on the ribbon and data is renewed:

enter image description here

Gennady G
  • 996
  • 2
  • 11
  • 28