How To Subtotal Weekly Data By Months

[Karthik]

Hi,


I've a set of weekly data as shown in the doc here (https://docs.google.com/spreadsheet/ccc?pli=1&key=0Ao7RzFobcTErdC1WbjFDVVlza29SU1ZuVE03VmlxQlE&hl=en_US#gid=0) I need a formula to fill the table that is to the right of the list with data related to that particular month and year.


Any help is much appreciated!

 

[NARAYANK991]

Hi Karthik ,


Try the following formula in cell E2 :


=SUMPRODUCT(($B$2:$B$32)*(--(YEAR($A$2:$A$32)=$D2))*(--(TEXT($A$2:$A$32,"mmm")=E$1)))


Copy this formula to the other cells in the range E2:H4 ; there is one date in May 2009 whose amount will not appear in your table which is only for Jan , Feb , Mar and Apr.


Narayan


P.S. This need not be entered with CTRL SHIFT ENTER.