Hello,
I am trying to use a formula across a google sheet.
Example: Column C has this formula: =Sumproduct('Volume and SL'!$O4:$O10,'Volume and SL'!$C4:$C10)/SUMPRODUCT('Volume and SL'!$C4:$C10). The each row 5 -57 look like that only the numbers change to reference a different cells on another page. I need to use that same formula in Column G but I need to have the Column letters change. Example: =Sumproduct('Volume and SL'!$P4:$P10,'Volume and SL'!$D4:$D10)/SUMPRODUCT('Volume and SL'!$D4:$D10). Any suggestions? Do you need more informtion?
Solved by O. D. in 17 mins