Average without #VALUE!

Copper Contributor

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

Crackeriano_0-1582632291226.png

 

3 Replies

@Crackeriano 

=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.

@Riny_van_Eekelen  thanks a lot for your quick reply!

It worked! Best regards and thanks!

 

 

 

 

 

You're welcome!

@Crackeriano