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     www.energyefficientbuild.com.    Apr 21, 2013
user sintl :(http://productforums.google.com/forum/?zx=1vygtkr9jaqa#!mydiscussions/docs/7DdQy9p6rVw)
Query formula, how to remove label and get sum <= certain date
Hello,
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
Sum
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
Sintl

---

Thanks Yogi, 

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

https://docs.google.com/spreadsheet/ccc?key=0AnVO1W9RSxhydENrTk1CQVJmbXJsdE9ELWpmU1hDUGc#gid=1

Thnx

------------------------------------------------------------------------------------------------------------------------

let us have a look at the following

yogi_Sum A Column Of Numbers Corresponding Month Of Which Is The Same As The Month Of Date In Cell B2

                                          Google Spreadsheet   Post  #1130
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 15, 2013
user sintl :(http://productforums.google.com/forum/?zx=9y7wjsaj5nsz#!category-topic/docs/spreadsheets/qCyHSepjtLM)
Sum for Month based on Date Criteria
Hello, 

In Col B (B5:B) i have dates (dd-mm-yyy) and Col E (E5:E) i have values, in B2 i have a date 4/04/2013

I want to sum for all dates which fall in month of April and when my dates change in B2 resultant sum value should change to corresponding month of date

Sample Data

Col B 
14/04/2013
15/04/2013
16/04/2013
05/05/2013

Col E
100
50
20
5

Sum Result should be 170 since my b2 falls under month april, if I change date in b2 to any may date it should give result of May which is 5

Thnx
----------------------------------------------------------------------------------------------------------
following is a solution to the problem