Thursday, January 10, 2013

yogi_Compute Number Of Kids In A Family By Specified Age Brackets


                                          Google Spreadsheet   Post  #963
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 10, 2013
user Robert Warburton said:(https://productforums.google.com/forum/#!mydiscussions/docs/UyEzfC3wnFQ)
counting the number of occurences within a range (counting # of kids within certain age range) 
https://docs.google.com/spreadsheet/ccc?key=0Aqhh0J9K80RFdDZEWk5FNGVmeHNMLWw5TWh4NTNGLUE#gid=0

I have a spreadsheet that determines the ages of kids based upon their birthdate.  I would like to have a formula in google spreadsheet that would count the number of kids in an age range (e.g. under 2 yrs old, 2-3, 4-5 ,etc).  The sample spread sheet is at the link above.

I can get this done in Excel with IF functions, but cannot seem to get anything to work in google sheets.

Any suggestions?

Thanks,
Rob

-------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment