## Thursday, November 29, 2012

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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 29, 2012
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

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

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