Excel, auto refresh consolidation statistics -


what if have list of activities , every day fix how many hours spent reading, writing, etc.

and want see summary date field, example 17 july walking 4 hours , reading 7 (total 11):

enter image description here

i added consolidation left column, described in video: https://www.youtube.com/watch?v=igaq_biq1b8

but how make statistics aut-updating(later i'll add other records statistics ends 20 july)?

ok, understand can create pivot table near. not recalculate values "on-the-fly", can press "refresh all" on ribbon , data renewed:

enter image description here


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -