Forum Discussion

Erica Fulton's avatar
Erica Fulton
Copper Contributor
Jul 07, 2017

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)

Resources