Friday, February 11, 2011

yogi_ClassCountByGradeAndGender


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com






following is from Bliz2011 ... this is a sample of the columns I am working with. I need the command to count the number of 7th graders and put the total in one cell. Once I figure that out. I'm going to write one to count the 8th graders, males, and females. Thanks for your help.
--------------------------------------------------------------------------

In the following spreadsheet I have used the COUNTIF function as well as the QUERY function