Forum Discussion
How to move formula
I have formula example as below: =SOM.ALS($M$5:$M$19;$AK$4;$Z$5:$Z$19)+SOM.ALS($M$5:$M$19;$AK$5;$Z$5:$Z$19)+SOM.ALS($M$5:$M$19;$AK$6;$Z$5:$Z$19)+SOM.ALS($M$5:$M$19;$AK$7;$Z$5:$Z$19)+SOM.ALS($M$5:$M...
If you want the range references to change as you copy the formula down the column, then you could omit the $ in front of the row references (the $ fixes the row/column references). Also, I think you could shorten your formula to
=SOM(SOM.ALS($M5:$M19; $AK$4:$AK$14; $Z5:$Z19))
If you don't have office 365, then you would need to hit Ctrl+Shift+Enter after keying/copying the formula to the formula bar, or use sumproduct instead of the sum function.
=SOM(SOM.ALS($M5:$M19; $AK$4:$AK$14; $Z5:$Z19))
If you don't have office 365, then you would need to hit Ctrl+Shift+Enter after keying/copying the formula to the formula bar, or use sumproduct instead of the sum function.