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    Jan 10, 2013
user Robert Warburton said:(!mydiscussions/docs/UyEzfC3wnFQ)
counting the number of occurences within a range (counting # of kids within certain age range)

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?


following is a solution to the problem