Monday, April 15, 2013

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