Hello,
I am working on a project involving determining a factor based on a CPI table.
The solution I am seeking involves 2 pieces of data, one of which I have worked out using match and index and some other formulas.
The 2nd part is a little more challenging. I need to be able to select usually from the same row( yr) a starting month and ending month, for example, Jan 2020 thru May 2020 and determine the avg.
The user will select the Months using data validation which I already have set up. But I cannot conceptualize how to have it give me an avg for a period of time selected. Any help will be appreciated.
Below is a link to the file
I am working on a project involving determining a factor based on a CPI table.
The solution I am seeking involves 2 pieces of data, one of which I have worked out using match and index and some other formulas.
The 2nd part is a little more challenging. I need to be able to select usually from the same row( yr) a starting month and ending month, for example, Jan 2020 thru May 2020 and determine the avg.
The user will select the Months using data validation which I already have set up. But I cannot conceptualize how to have it give me an avg for a period of time selected. Any help will be appreciated.
Below is a link to the file
Attachments

33.8 KB Views: 12