Tuesday, July 17, 2012

yogi_Compute Count And Sum Data From Another Sheet Based On Multiple Criteria

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #634   Jul 17, 2012     www.energyefficientbuild.com.

user Angie0631 said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/MidrltuL0j4)
A formula that does Excel "countifs" function involving dates
I have a Google spreadsheet in which multiple users are tracking a list of dates and class names (math, reading, writing, etc). On a separate sheet in the same document, I want to be able to give a count of how many times each class name shows up within a particular date range. Here is a sample workbook: https://docs.google.com/spreadsheet/ccc?key=0AlMRSUls9YJDdEZqeU9VaFJCbDJOZlpkRG0zcktHYnc
To rephrase the question, on the page "stats" in columns E:J I want to count how many times the classes listed in Row 4 are showing up in Column E of the sheet "summer" between the dates listed. For example, in "stats" cell E6, I want to know how many times a user entered Math on the sheet "summer" in the period July 9-13.
In Excel I would do this with the countifs formula, but that doesn't work in Google Docs. Does anyone know about a work-around I could use in this situation?
Thanks in advance!
following is a solution to the problem