Sunday, June 25, 2017

yogi_Count Instances Of Entities By Specified Age Groups

Google Spreadsheet   Post  #2193
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-25-2017
question by sarahcatherine:
https://productforums.google.com/forum/#!topic/docs/s_05I07vtGA;context-place=forum/docsFilling blank date cells with previous entry

Adding up instances in a spreadsheet that meet a certain criteria

I have a complicated spreadsheet issue... I am collecting a lot of data in a form. It includes names of individuals along with sex and birth dates.  I need an equation that can simplify the data and identify the number of adult males, adult females, children, babies and newborns based on the dates of births and sexes entered. Sample spreadsheet.

I think I need to use the countifs function but can't seem to get it work... 

Any ideas?