Are you sure about the criteria you state and the range for which a
conditional max must be calculated? As is, they sound unusual...
Tom Hollies via OfficeKB.com wrote:
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
|