Thursday, April 26, 2012

yogi_Sum Up Amounts By Month And Year From A Table Of Dates And Amounts

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #517    Apr 26, 2012     www.energyefficientbuild.com.


user Hoopsnl said:
Sum per month in a specific year 
Hi,
Hopefully someone can help me;
I have several dates in a spreadsheet and I want to have the monthly total per month per year, my table;
Date                Total
(MM/DD-YYYY) 
01/02/2011            100
01/08/2011              5
02/02/2011              6
02/08/2011              6
09/02/2011             10
01/02/2012             12
01/22/2012             12
04-06-2012              5
04-08-2012              5
12-10-2012              6 
12-25-2012              6
Result should be:
Month      Total
Jan 2011     105
Feb 2011      12
Sep 2011      10
Jan 2012      24
Apr 2012      10
Okt 2012      12
Who can help ?

----------------------------------------------------------------------------------------
following is a solution to the problem ... in Sheet1 I have shown Month numbers instead of Month names