Hi Team Excel
I am at a loss as to why this array formula works for my horizontal values but wont work vertically. I am sure there is a simple reason, but i am still learning all this and i dont know what it is, please help.
Attached is a very simple table. It contains letter grades, which are then reference a number value from another table (_Reports) to give it a numerical value, so that it can then be averaged, before changing it back into a Letter grade again. This works if i place the array formula in the horizontal average cell, but wont work if i try an average down a column.
Bookmarks