=MAX(IF(ISNUMBER Assistance

[Graham C1600]

Hi,

I've been using the following formula which is working fine for my current needs :-
{=MAX(IF(ISNUMBER(CB:CB),IF(A:A="Set 107",CB:CB)))}

I now want to add another criteria to this function after A:A="Set 107" to B:B="Ready"

I've tried various options but am not getting the correct answers.

Can somebody advise where I need to add the second criteria for the function ?

Thanks

 

[Fluff]

Try
=MAX(IF(ISNUMBER(CB:CB),IF((A:A="Set 107")*(B:B="ready"),CB:CB)))

But I would recommend against using whole column references in an array formula.