To avoid these issues, you can use the AGGREGATE function instead. The AGGREGATE Function . The AGGREGATE function is similar to the SUBTOTAL function, but there are more options ...