Do you mean the number has to be in both columns, or that whichever column
it is found in it adheres to the rules for that column alone. What do you
want returned if there is no value that meets the criteria.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Tom Hollies via OfficeKB.com" wrote in message
...
Hi,

Hi,
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.
Any Ideas regards Tom

--
Message posted via http://www.officekb.com