Results 1 to 5 of 5

Thread: Variable Cell Range

  1. #1

    Variable Cell Range



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

    Hi,

    Looking for a formula that will change the cell range dynamically based on a variable in another cell.

    For Example: I have numbers 1 - 10 in A1:A10
    @ c4 =sum(A1:A4)
    @ e10 = 4

    If I change the number in E10 from 4 to 7, then at C4 the sum should automatically change to sum(A1:A7)

    -Balki

  2. #2
    Try

    =SUM(A1:INDEX(A:A,E10))

  3. #3

    Cool

    Quote Originally Posted by Bob Phillips View Post
    Try

    =SUM(A1:INDEX(A:A,E10))
    Yes. This works perfectly. Thank you very much.

  4. #4
    Hello Bob,

    I used the Index in below:

    COUNTIF(Data!C4:INDEX(C:C,S3),"Pending")

    What I am trying to achieve is get the count from Sheet name "Data" if the text = "Pending".
    The range C4 to Cx will be decided by the value in S3

    Regards,
    Balki

  5. #5
    Hello Bob,

    Tx. Got it right this time. It should have been COUNTIF(Data!C4:INDEX(Data!C:C,Data!S3),"Pending")

    Regards,
    Balki

Posting Permissions

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