Sum entire column in excel except for certain rows [closed]

Question

For a spreadsheet of mine, I want the sum of an entire column, no matter how many entries a column is. This was previously solved by

=SUM(A:A) 

but I was wondering if there was a way to do all but the first 2 rows of column A.

=SUM(A2:A)

does not work. Thanks in advance!

Answer 1

You could use

=SUM(A:A)-SUM(A1:A2)

or, if you know that the cells you exclude are numeric,

=SUM(A:A)-A1-A2

Answer 2

MrExcel has a couple of suggestions:

=SUM(A3:A65536)

OR

=SUM(A3:INDEX(A:A,MATCH(9.99999999999999E+307,A:A)))