Hi All.
I want to pull an average from the last 2 years in another workbook, but it only works when the other workbook is open.
The formula i have now is:
=AVERAGEIFS(Path..$BU:$BU;Path..$B:$B; B4; Path..$F:$F; ">"&TODAY()-(Q8*360))
BU:BU = Numbercolumn
B:B = Materialnumbers
B4 =...