Hello dear members of the forum. I'm trying to design a formula that allow me to simplify some calculations. I have 35 columns of data.
In cell B90 I should execute this formula:
<tbody>
</tbody>
As it can be observed the range is reduced by 1, each time I change column. What I did was to include a row with produces the number associated to the row on each formula: so I have the 78, 77 and so on.
I also included a formula in another row whose output is the letter of the column (B, C, etc.)
What I would like to have is another formula that allow me to bind those previous results, producing automatically the formulas I need for each column, so I don't have the edit the range of the sum if I copy the traditional sum formulas.
I can send an example if somebody need it in orden to understand better.
In cell B90 I should execute this formula:
=sum(C44:C78)/sum(B44:B78) In cell C90 the following:
<tbody> </tbody> |
<tbody>
</tbody>
As it can be observed the range is reduced by 1, each time I change column. What I did was to include a row with produces the number associated to the row on each formula: so I have the 78, 77 and so on.
I also included a formula in another row whose output is the letter of the column (B, C, etc.)
What I would like to have is another formula that allow me to bind those previous results, producing automatically the formulas I need for each column, so I don't have the edit the range of the sum if I copy the traditional sum formulas.
I can send an example if somebody need it in orden to understand better.