I need to sum column 2 based off of a given date. My data table is huge and I need to sum every individual months data over past years to display on another sheet.
Given Date (1/20/2009, 2/28/2009, etc.)
[TABLE="width: 112"]
[TD="align: right"]1/2/2009[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]1/5/2009[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]1/6/2009[/TD]
[TD="align: right"]0.05
[/TD]
[/TABLE]
[TABLE="width: 112"]
[TD="align: right"]2/2/2009[/TD]
[TD="align: right"]0.19[/TD]
[TD="align: right"]2/3/2009[/TD]
[TD="align: right"]0.28[/TD]
[TD="align: right"]2/4/2009[/TD]
[TD="align: right"]0.26
[/TD]
[/TABLE]
Any help would be greatly appreciated. Thanks!