Thursday, November 29, 2012

yogi_Group In Sheet2 The Sum Of Values In Column D By Month Of Dates In Column C Of Sheet1

                                          Google Spreadsheet   Post  #899

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Nov 29, 2012
user Nathan Gibson said:(!category-topic/docs/spreadsheets/Oa3NjbWNVIY)
get the sum of a cell depending on the DATE value of another Cell 
I have spreadsheet1 with column C listing a date in MM/D/YYYY format and Column G listing a dollar Amount. 

I need a formula to parse speadsheet1 and find all dates in comlumn C for January and add Column G and post it in spreadsheet 2. And so on for each month

Spreadsheet 1  <----What I got

C                      G
1/1/12               $5.00
1/5/12               $5.00
2/5/12               $10.00
2/12/12             $7.00
3/15/12             $2.00
5/22/12             $9.00
6/16/12             $6.00

Spreadsheet 2:  <-----What I need

A                B

January       $10.00
February     $17.00
March         $2.00
April            $0.00
May            $9.00
June            $6.00

I am not a spreadsheet master but I was working down this path but haven't really got anywhere:  =ArrayFormula(sum( (month(C2:C)=9)*E2:E ))

Any help would be appreciated.
I have a hunch you want to group in Sheet2 sum of values in column D by month of dates in column C of Sheet1 -- for this ... for this I have presented a solution in the following