On Jun 14, 8:51 am, hmm wrote:
The function =MAX(A:A) is giving a #N/A error because some of the cells in
column A are errors.

Is there a way to tell MAX to ignore errors (perhaps by putting A:A into
some sort of filter function)?


You could also use this formula:

=MAX( IF( ISERROR(A1:A100), "", A1:A100 ) ) which doesn't use the NOT
function

Again it must be entered as an Array formula Ctrl+Shift+Enter