how do I deduct furthest south cell from furthest north cell? Ollie 29.09.2006 13:43:01 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.

Re: how do I deduct furthest south cell from furthest north cell? "Don Guillett" <dguillett1[ at ]austin.rr.com> 29.09.2006 13:44:45 use MATCH to look for a number larger than possible and subtract that -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "Ollie" <Ollie[ at ]discussions.microsoft.com> wrote in message news:F30AB73A-1AF4-4C26-B5C7-7B9CDD05B3FE[ at ]microsoft.com... [Quoted Text] > 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.

Re: how do I deduct furthest south cell from furthest north cell? "RagDyeR" <ragdyer[ at ]cutoutmsn.com> 29.09.2006 15:39:09 Try this: =A1-LOOKUP(99^99,A:A) -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Ollie" <Ollie[ at ]discussions.microsoft.com> wrote in message news:F30AB73A-1AF4-4C26-B5C7-7B9CDD05B3FE[ at ]microsoft.com... 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.

Re: how do I deduct furthest south cell from furthest north cell? Gord Dibben <gorddibbATshawDOTca> 29.09.2006 16:43:08 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 <Ollie[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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.