Forum Discussion
Erica Fulton
Jul 07, 2017Copper Contributor
Functions for rows and columns
Hi,
I am trying to do the sum of a row and am wondering if i can apply it to an entire column. For example, I do =sum(b3:m3) and get the sum in n3 but I am trying to do this for n3 to n2000. Is there a way to do this instead of dragging it down the column?
Thank You
Hi Erica,
For the reference on entire column just skip row numbers
=SUM(N:N)
Similar if you'd like to sum entire row use only rows' number like
=SUM(10:10)