With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, December 5, 2015
yogi_Create Filter View With Dynamic Updating Of Computed Stats Such As Average Age Of Select Gender(s) Living In Specified Town(s)
post by Mark Erhard: https://productforums.google.com/forum/#!topic/docs/jxn4nk77Acs;context-place=forum/docs Calculation depending on Filters in Sheets Hi, i have a List of People with a few columns, like Age, Gender, Town and other factors.
Now i have a filter view and want to be flexible and sometimes filter for all females, from town A.
I have a row below that list, that shows me for example the average Age of all in the List.
Now if i use the filter, the results of the Average Age doesnt change. It still shows the average age of the whole group.
Is there a way to change that and to calculate the result depending on the filter???