Hi,

I have attached an example spreadsheet. It's much easier to understand what im trying to do if you have the spreadsheet open. ex.xlsm

so i have some values (val1.....val6) that i would like to sum for each month.

row 2 - 8 sum values for jun12, row 10 - 16 sum values for jul12, row 18 - 24 sum values for aug12....i have more months listed on my actual sheet but i have only listed jun12, jul12, and aug12 for this example


below row 25 are values from various months that are summed in row 2 - 8 for jun12, row 10 - 16 for jul12, row 18 - 24 aug12.


i need a code or formula that will sum the values for jun12 (like the jun12 in B29, B36, B53) and populate them in appropriate cells above row 25...in the case of jun12 it should populate the sums in row 3-8. for example cell B3 is the sum of B29+B37+B53

the data below row 25 could go on for any number of rows...so the code would need to be able to first check is there is any value in B60 for example, if there is text in B60 like "jul12" then it would need to sum all the jul12 values and populate them in rows 11-16...

no matter how many rows there are below row 25, the format of the sheet would not change...what i mean by this is that all additional data would have spacing of one row like you have in row 33, 41, 49 etc..

i would like this so that if my values below row 25 are changing in realtime the summed values above row 25 should also update realtime. please let me know if this is clear...thanks in advance