thanks domenic,

that does work for the excel example; however, if you put lets say $100
into AN3, making the total in cell AT3 $100. Your formula will
recognize AT3 and return the result 21.

The more I thought about it, what I need is a formula that will start
the search at AT33 and move up (AT32, AT31 and so on) until it finds a
# 0. Lets say it finds a value of 200 in AT18, it would then go to
AU18-1, to return 10.

any ideas?


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=542239