Feb 25 2020 04:08 AM
Hello all.
I'm trying to make an average without counting the #VALUE!, i've searched some help and found a array formula but it still doesn't work.
Can you help me? What am i doing wrong?
best regards
Feb 25 2020 05:49 AM
=AGGREGATE(1,6,<range>)
The 1 means "average" and the 6 to ignore errors. You can read more about it in the help screen for the AGGREGATE function.
Feb 25 2020 11:07 AM