I think this is a simple one, and I have seen the solution here before, but I have been unable to search it out.
Here is what I have
1. Have a COUNT value in a cell (counted the number of rows with values in them).
2. A formula that needs this value (sums another set of values in another column that has the same number of rows).
Example: the COUNT value is 12, and is located in cell G5. For simplicity sake I have a formula in cell I5 SUM(F1:F12). Instead of directly referencing F12, I want the formula to be SUM(F1:F(G5)).
Is this possible?
Here is what I have
1. Have a COUNT value in a cell (counted the number of rows with values in them).
2. A formula that needs this value (sums another set of values in another column that has the same number of rows).
Example: the COUNT value is 12, and is located in cell G5. For simplicity sake I have a formula in cell I5 SUM(F1:F12). Instead of directly referencing F12, I want the formula to be SUM(F1:F(G5)).
Is this possible?