# I Want to Link a Variable Range with Multiple Formulas

1. ## I Want to Link a Variable Range with Multiple Formulas

Hi,
Let me explain my issue

Let, I have data in column F from Cell E4 to E18. Now I have to find five different values using formulas: Sum, Plus Count, Negative Count, Highest and Lowest (as you can see from the Attached Excel File)
I have found all these values for the Range of E4 to E10 (E4:E10)

My Requirement:
I want to link Ranges of these 5 formulas with cells B4 and C4 (Cell B4 and C4 make basically a series staring and ending values)

Now whenever I have to find these five values for a specific range, I would only put required series starting and ending values in cells B4 and C4 respectively)

(Excel file is attached for further clarification)

2. ## Re: I Want to Link a Variable Range with Multiple Formulas

Hi,
You may apply like:

``Please Login or Register  to view this content.``
Good Luck !!!

3. ## Re: I Want to Link a Variable Range with Multiple Formulas

Originally Posted by John521520
My Requirement:
I want to link Ranges of these 5 formulas with cells B4 and C4 (Cell B4 and C4 make basically a series staring and ending values)

Now whenever I have to find these five values for a specific range, I would only put required series starting and ending values in cells B4 and C4 respectively)
Try
vba
``Please Login or Register  to view this content.``
Or just
1)Select G4:L4
2) Ctrl + H (find + Replace) replace E4:E10 with OFFSET(INDIRECT("e"&\$B\$4&":e"&\$C\$4),,,\$C\$4-\$B\$4+1)
Then the formula should work as you change any one of B4:C4.

4. ## Re: I Want to Link a Variable Range with Multiple Formulas

Hi,

My issue remans unsolved. I tried your code but it does not work.

5. ## Re: I Want to Link a Variable Range with Multiple Formulas

I tried your code but it does not work.

6. ## Re: I Want to Link a Variable Range with Multiple Formulas

@sungjunbae

You need to include code tags around your code.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

7. ## Re: I Want to Link a Variable Range with Multiple Formulas

@John521520

Please make it clear to whom you are responding in each case, as I have done in this post. Thanks.

8. ## Re: I Want to Link a Variable Range with Multiple Formulas

Originally Posted by John521520
I tried your code but it does not work.
That's a WORST response.

How is it not working?

see attached.

9. ## Re: I Want to Link a Variable Range with Multiple Formulas

Thanks a lot, it worked

10. ## Re: I Want to Link a Variable Range with Multiple Formulas

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

11. ## Re: I Want to Link a Variable Range with Multiple Formulas

Thanks Ali,

``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)