Forum Discussion
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 ...
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)