Monday, June 11, 2012

yogi_Extract Totals Of A Range Of Columns And Present Results By Month Based On Dates In Column 1

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #588    Jun 11, 2012     www.energyefficientbuild.com.

user Nieboy1 said:
Column filter and return number of rows with requested filter attributes
I am Trying to filter a column and return a the number of rows that fit the filter query.  I am unfortunately not too familiar with anything but the basic use of equations in spreadsheets so any help would be greatly appreciated.
-----
 here is the spreadsheet I am referring to https://docs.google.com/spreadsheet/ccc?key=0AuXtZZ2omsU_dFJhVFdfM0dSR2ZfTklKakFnVW5WSVE im trying to have the form submissions get tallied up according to there corresponding month like I have done in the derivatives sheet under Contracts. 
------------------------------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment