Aggregate Function showing #DIV/0!

[Poenankie]

Dear All,
I use an aggregate function to determine the average of the non-error values in a list, once the list is populated it works perfectly, however while the list is empty it returns "#DIV/0!".

In such instances I want the formula to return a blank, however, as much as I try I can't get a formula to work.

The basic formula is =AGGREGATE(1,6,G12:G42).

I hope this is even possible.

Regards,
Poenankie

 

[alpha_Q]

Hi,

Try: =IFERROR(AGGREGATE(1,6,G12:G42),"")

aQ

 

[Poenankie]

Hi Alpha_Q,

Thank you, it did the job, I tried it before and it gave the wrong answer, I just realized I accidentally included extra cells

Regards,
Poenankie