I have this matrix:
Average_Intersect.png
What I want is a formula that will:
1. Identify each element in the "x" columns that intersect with the "w" rows.
{3;9;5;7}
2. Calculate the average of that return.
AVERAGE(3;9;5;7) = 6
So the final result has to be 6.
Any ideas?
Bookmarks