I need help with Vlookup or any other function which can show me the average for a range,
I do not want to use an extra column to calculate the Average.
I am enclosing a sample file with the result I expect and the formula I tried which is not working
Basically, I was trying to use the AVERAGE function for Column Index number.
Any help would be greatly appreciated.