Steve,

That formula gave me a #VALUE! error, perhaps because I am dealing with
strings as well as numbers.

The real difficulty has been to specify the row that has BOTH a blank in A
and the highest balance in I. I figured out a way to do that - to find the
rows with blanks, and search for the highest balance - BUT if there are
multiple rows with the SAME high balance, then it will give the first row in
descending order with that balance REGARDLESS of whether or not A is blank.

I can't ensure that the columns will be sorted, which is another
restriction. Do you know of a way to ensure that the tables get sorted a
specific way everytime the worksheet is opened?

Aaron

"SteveG" wrote:


Aaron,

Try,

=IF(SUMPRODUCT((Bucket!A1:A65000="")*(Bucket!I1:I6 5000=MAX(Bucket!I1:I65000))*(Bucket!B1:B65000))0, SUMPRODUCT((Bucket!A1:A65000="")*(Bucket!I1:I65000 =MAX(Bucket!I1:I65000))*(Bucket!B1:B65000)),"Empty ")

This is not an array formula. All of the ranges must be the same size
for this to work. Also, if there is more than one occurrence where A
is blank and I is the max value of the column it will sum the values in
B.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=569136