Sum Entire Column Starting at Row 4

Jennie Hoffmann

I want to insert a Sum formula into Row 3 that will Sum all the rows in the column beginning at row 4 and continuing to sum any new rows that are added to the column. It seems like it should simply be

=SUM([ColumnA]4:[ColumnA])

but this gets an #Unparseable error.

How might I create a Sum excludes everything above Row 4 but includes everything below Row4?

Thanks

Jennie

kowal

hi @Jennie Hoffmann,

so when you choose a range for any formula you can choose specific rows or you choose entire column.

so instead of =SUM([ColumnA]4:[ColumnA])

you shall have something like =SUM([ColumnA]4:[ColumnA]20) - it's limited for rows from 4 to 20

or you can have =SUM([ColumnA]:[ColumnA]) so it takes entire column as a range and you can make those calculations in Sheet Summary.

Btw as ColumnA is only one word you do not need [] brackets those are only if you have name of the column as two words like Column A.

Hope this helps.