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/
-------------------------------------------------------------------------------
https://docs.google.com/
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