example: If I put '3000' in Cell 'A1' and in colomn 'A' there are repeated
numerical amounts being added ie 'A3 50, A8 32, A13 68' what sum would I need
to deduct the furthest south cell 'only' from the '3000' in cell A1.

use MATCH to look for a number larger than possible and subtract that

--
Don Guillett
SalesAid Software

"Ollie" wrote in message
...
example: If I put '3000' in Cell 'A1' and in colomn 'A' there are repeated
numerical amounts being added ie 'A3 50, A8 32, A13 68' what sum would I
need
to deduct the furthest south cell 'only' from the '3000' in cell A1.

Try this:

=A1-LOOKUP(99^99,A:A)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Ollie" wrote in message
...
example: If I put '3000' in Cell 'A1' and in colomn 'A' there are repeated
numerical amounts being added ie 'A3 50, A8 32, A13 68' what sum would I
need
to deduct the furthest south cell 'only' from the '3000' in cell A1.

Ollie

=A1-LOOKUP(9.99999999999999E+307,A:A)

Entered in B1


Gord Dibben MS Excel MVP

On Fri, 29 Sep 2006 06:43:01 -0700, Ollie
wrote:

example: If I put '3000' in Cell 'A1' and in colomn 'A' there are repeated
numerical amounts being added ie 'A3 50, A8 32, A13 68' what sum would I need
to deduct the furthest south cell 'only' from the '3000' in cell A1.