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)

Google Spreadsheet   Post  #1987
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-05-2015
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???

Would be a great help!!!!
-------------------------------------------------------------------------------------------------------------------------------------------