C
Chap
In my workbook, one worksheet (Tab1) should contain several formulas
structured as:
=AVERAGE('Tab2'!Address1:Address2)
The other worksheet (Tab2) contains a table, in which column A are all dates
from the last 5 years, in ascending order, and column B the corresponding
target values.
Address1 and Address2 are the cells in column B of Tab2 located on the same
rows as the cells in column A that contain Date1 and Date2, respectively.
Date1 and Date2 are cells (containing dates) in Tab1.
My goal is to have each formula in Tab1, given Date1 and Date2, calculate an
average of target values retrieved from the table in Tab2.
How should I complete the formulas? Should a Lookup function be used?
Many thanks.
Chap
structured as:
=AVERAGE('Tab2'!Address1:Address2)
The other worksheet (Tab2) contains a table, in which column A are all dates
from the last 5 years, in ascending order, and column B the corresponding
target values.
Address1 and Address2 are the cells in column B of Tab2 located on the same
rows as the cells in column A that contain Date1 and Date2, respectively.
Date1 and Date2 are cells (containing dates) in Tab1.
My goal is to have each formula in Tab1, given Date1 and Date2, calculate an
average of target values retrieved from the table in Tab2.
How should I complete the formulas? Should a Lookup function be used?
Many thanks.
Chap