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?
The 1 means "average" and the 6 to ignore errors. You can read more about it in the help screen for the AGGREGATE function.
@Riny_van_Eekelen thanks a lot for your quick reply!
It worked! Best regards and thanks!