Forum Discussion
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 each column. For example 3. column, =sum(b3:k3).
How can I do that? Thank you.
2 Replies
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.
Riny_van_Eekelen thank you so much
