A way to get the cell references in a formula change

Is there a way of getting the cell references in a formula change following a change in the content of a cell in the worksheet ?? Please see attached file.
Any help will be much appreciated

I think you need to clarify in terms of whether or not the value in I8 is an any way tied to the data table - ie is January actually listed anywhere or are you simply saying that you interpret each "block" of data in your table to be associated with a month, ie first block is Jan, second block is Feb etc... your life would be a lot easier if Jan, Feb etc were listed alongside the transactions in your table.

Using your sample file:

Please Login or Register  to view this content.

If the SUM value is in G8 etc then perhaps:

Please Login or Register  to view this content.

Originally Posted by Michael6

Hallo,
In your last reply to my question regarding the averages, the code you suggested gives the average that is equal to [the sum of the values of each item divided by the number of times the item appears in the table.] But what is actually required is the weekly average of each item, which is [the sum divided by the number of rows from the start of the month in G4 to the last entry of the item in the table]. The main issue is the row number of the last entry of each item less the row number of the start of the sum range (which changes as a different month is entered in cell G4).
Sorry to bother you, but I can't see any other way after all the unsuccessful attempts I made to sort out this issue myself.
Regards
Michael

Given amount of repetitive calcs being performed (match of Month) I would suggest the following revisions (using your last sample file)

Please Login or Register  to view this content.

*H4 provides the match of month number which is used consistently in latter calcs - better in XL to calc once, store & refer to the result via cell reference than repeatedly calc in each formula given the result is "constant" (ie does not change per calculation)