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.
Thursday, January 10, 2013
yogi_Compute Number Of Kids In A Family By Specified Age Brackets
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.