Hi,
I'm using MAX with SUMPRODUCT to find the maximum value in a range based on a corresponding range of TRUE/FALSE criteria. The problem is when the values are all negatives, the formula result equals zero when it should equal the smallest negative value.
In column A, I have -1, -2 and -3
In column B, I have TRUE, TRUE and FALSE.
The formula is =SUMPRODUCT(MAX((B1:B3=TRUE)*(A1:A3)))
Now, I could use the LARGE function, but why does MAX evaluate to zero when it should evaluate to -1???
Thanks,
Lawrence
Bookmarks