Forum Discussion
Solved
average non-contiguous cells while ignoring #N/A errors in excel
Hello, I need to enter a formula that will calculate the average of three non-contiguous cells across a row of data, while also accounting for - and excluding - cells containing #N/A. This formula ...
=AGGREGATE(1,6,J9,N9,R9)
Is this the formula you are looking for? I entered formula in T9 and copied down.
=AGGREGATE(1,6,J9,N9,R9)
Is this the formula you are looking for? I entered formula in T9 and copied down.
- Thank you very much. Yes, that works perfectly! I did see that function and didn't quite understand the application. But I see what you did and it makes perfect sense.
