one way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(C2:C403,C2:C40),IF(D2:D4025,D2:D40))


In article ,
"Tom Hollies via OfficeKB.com" wrote:

I wonder if anyone can help, I have 2 columns say C2:C40 and D2:D40 and I
need to add a function to say D50 that will return the Max for both columns
provided the number is 3 in column C and 25 in column D.