Stretch a vertical formula horizontally
Solved
Camus01
-
Camus01 -
Camus01 -
Hello, I have a problem with a formula that I would like to extend.
The base data is placed in the first tab.
This data is pre-processed via a Pivot Table in the second tab (Pivot Table Group EI).
It needs to be synthesized again in the third tab. That's where I'm stuck.
I would like to extend horizontally the formulas in column D (e.g., D3=SUM('Pivot Table Group EI'!B4:D4)/1000) so that only the row argument changes. E3=SUM('Pivot Table Group EI'!B5:D5)/1000 F3=SUM('Pivot Table Group EI'!B6:D6)/1000 ....
Currently, when I extend my formula, the columns change.
Thank you in advance.
The base data is placed in the first tab.
This data is pre-processed via a Pivot Table in the second tab (Pivot Table Group EI).
It needs to be synthesized again in the third tab. That's where I'm stuck.
I would like to extend horizontally the formulas in column D (e.g., D3=SUM('Pivot Table Group EI'!B4:D4)/1000) so that only the row argument changes. E3=SUM('Pivot Table Group EI'!B5:D5)/1000 F3=SUM('Pivot Table Group EI'!B6:D6)/1000 ....
Currently, when I extend my formula, the columns change.
Thank you in advance.
It’s not ideal, but I will take this solution for the moment.
Thank you