Forum Discussion
mehmetali001
Jun 19, 2020Copper Contributor
Sum Formula
I want to create a function and fill all the columns. My function is summing the data in its line. For example =sum(b2:k2). Then, i wanna fill 50 columns with this formula but i dont want to write ea...
Riny_van_Eekelen
Jun 19, 2020Platinum Contributor
mehmetali001 I believe you are asking for how to copy a formula down a column.
The small square in the bottom-right-hand corner of the cell lets you drag the formula down the column. Double click it and it will automatically copy the formula down, as long as there is data in column K.
- mehmetali001Jun 19, 2020Copper Contributor
Riny_van_Eekelen thank you so much