Results 1 to 2 of 2

Thread: Cell text to cell location

  1. Jul 4th, 2003, 05:31 AM #1
    gerb4u
    gerb4u is offline

    Thread Starter
    Junior Member gerb4u's Avatar
    Join Date
    Sep 2001
    Location
    Cork, Ireland
    Posts
    26

    Cell text to cell location

    Hi,
    I have a cell with address information (address function). Now i want to sum a number of cells up to that address.
    Any idead how I would do this.

    ie sum(a10:ADDRESS(10,(E7),4))


    Regards
    Ger
    Reply With Quote Reply With Quote
  2. Jul 8th, 2003, 08:41 AM #2
    BrandonSk
    BrandonSk is offline
    Addicted Member
    Join Date
    Aug 2000
    Posts
    195
    Use INDIRECT(E7) instead ADDRESS.

    I suppose you have something like "J10" stored in E7.

    Then the sum looks like SUM(A1:INDIRECT(E7))

    Works?
    Brandon
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width