How to calculate the sum of all rows of a column starting from 3rd row ?

medisettinaveen

Column

row1 Total

row2 =SUM([Column3]:[Column])  this should be sum of all the rows starting from 3rd row

row3 1

row4 3

row5 25

row6 21

mohammad saaideh

Hi medisettinaveen ,

In row2 use this :

=SUM([Column name ]:[Column name ])-[Column name ]1