I am trying to average the values in column B of a table, based on a start date and end date given in cells D3 and E3 respectively. When I use the ADDRESS and MATCH functions in cells D7 as a first step in calculating the average, it returns a cell reference relative to the start of the range ($B$5) whereas I want $B$9, the actual cell location.
How do I get this please?
Many thanks in anticipation
David
How do I get this please?
Many thanks in anticipation
David