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)