For example this: MAXIFS(A14:A23,D14:D23,D24) Can be changed into something like this: MAX(IF(D14:D23D24,A14:A23)) Array Entered.

As I could not get the Aggregate working (even tho it could be faster) Thanks again for your help - Everything seems to be working now that I have copied it onto the master - And thanks for doing the other cells I copied and pasted those as well.

Please mark the thread as Solved if that took care of your problem.

I was wondering if someone could help me to change this formula to make it compatible.xlfn.AVERAGEIFS convert to 2003.

As a worksheet function, the AGGREGATE function can be entered as part of a formula in a cell of a worksheet.

Some conditional formatting can not be applied if there are errors in the range.

The Excel AGGREGATE function allows you to ignore errors or hidden rows.

If the options parameter is omitted, it assumes that options is set to 0.

If you ran the AVERAGE(A2:A7) function directly, it would return NUM error because of the errors found in cells A4 and A7.

The AGGREGATE function allows you to calculate an AVERAGE but ignore error values.

The AGGREGATE function below would instead return 34 (instead of NUM).

If you ran the LARGE(A2:B7,2) function directly, it would return NUM error because of the errors found in cells A4, A7, and B5.

The AGGREGATE function allows you to calculate the 2nd LARGEST value but ignore error values.

The AGGREGATE function below would instead return 26 (instead of NUM).

Xlfn Excel For Mac