AGGREGATE Function Code 2 Doesn't Ignore Errors

I am using the AGGREGATE function with option code 2 which should ignore other errors. However, I changed one of the cells being added to a divided by zero error, and the AGGREGATE function is resulting in an error instead of ignoring it. (For what it’s worth, I don’t know how the range was flipped to B16:B9 but the output is the same with the range as B9:B16.)

Thank you for reporting this issue. We are tracking this issue internally as #004287 & will address it in one of the upcoming releases.


Issue #004287 has been fixed with the latest upgrade

1 Like