Google Spreadsheet Post #899
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 29, 2012
user Nathan Gibson said:(http://productforums.google.com/forum/?zx=fgswwk4cu5xw#!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
