Sunday, April 21, 2013

yogi_Compute Stats Working With QUERY Function With A Field Of Mixed Data Type And Also Remove -- Characters

                                          Google Spreadsheet   Post  #1146
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 21, 2013
user sintl :(!mydiscussions/docs/7DdQy9p6rVw)
Query formula, how to remove label and get sum <= certain date
Following is my query formula, it works well but it gives results like below, I just want remove label sum and only get 79.5
=iferror(query('Data Entry'!$B$5:E,"select sum(E) where B = date '" & text($D$7,"yyyy-MM-dd") & "'"))
Also I want to update my formula to sum my column E till date indicated in D7 (basically total sum of E equal or less than the date in D7), Column B has various dates.

Thanks Yogi, 

I need some more help. Please see my spreadsheet sugesst me how i should resolve my indicated issues. 

let us have a look at the following