Monday, July 23, 2012

yogi_Count Submissions By Year And Month In Another Sheet

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


user Nieboy1 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/4cRXTQh4ml8)
simple count submittions query 
hi, I am looking to simply return the number of submitions for each month on a form spreadsheet ( https://docs.google.com/spreadsheet/ccc?key=0AuXtZZ2omsU_dDhXQ1VjallEVHE3YjFrQVhpT3VDc3c)
similar to the format that A11 in "Derivatives" on this workbook ( https://docs.google.com/spreadsheet/ccc?key=0AuXtZZ2omsU_dFJhVFdfM0dSR2ZfTklKakFnVW5WSVE )
I am hoping that it is a simple modification to that formula to accomplish this.
Thanks 
Ryan
------------------------------------------------------------------------------------------------------
following is a solution to the problem