Results 1 to 3 of 3

Thread: referring to a cell in a formula

  1. #1
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0

    referring to a cell in a formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to make some formulas such as, =count(A:A)
    my problem is I am making several formulas for those calculations, and I run out of system resources.
    I get that the better way to do this is to calculate for a range =count(A1:A5000)

    Now the question.

    Is there a way to refer to these cells with a value put in another cell.
    for example B1 = 1, B2 = 5000
    then the formula be something similar to =count(A&B1:A&B2)

    Also, I don't want to change to R1C1 because I also have several macro's that use the A1 format.
    Last edited by Simi; 2014-07-01 at 10:19 PM.

  2. #2
    Try

    =COUNT(OFFSET($A$1,B1-1,0,B2-B1+1,1)

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    Bob that is brilliant, thank you.

Posting Permissions

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