Friday, February 11, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

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