Hi,
I am trying to create a SUM function that will add SUM(X:Y).
Where X is the cell !!! below !!! the cell that contains the SUM solution.
And Y is the first blank cell in the column (or the cell above the blanc).
The X address is easy, but the Y address always various depending.
Another difficulty is the fact that the cell below the blank one will have the same formula.
So "row()" can't be used -I think-.
I know this has got to be fairly straight forward, but I can't figure it out.
Thanks
I am trying to create a SUM function that will add SUM(X:Y).
Where X is the cell !!! below !!! the cell that contains the SUM solution.
And Y is the first blank cell in the column (or the cell above the blanc).
The X address is easy, but the Y address always various depending.
Another difficulty is the fact that the cell below the blank one will have the same formula.
So "row()" can't be used -I think-.
I know this has got to be fairly straight forward, but I can't figure it out.
Thanks