sum entire column with heading rows

[hsg]

My worksheet contains first two or three rows as header.
rest is data.
Is is possible to use sum(a:a) kind of formula
to sum data in column A, which will exclude
the header rows.
It is done with sum (a4:a100) kind of formula, but "a100"
is likely to change

please help

 

[Dave Peterson]

If the headers contain plain old text, you can use:
=sum(a:a)
(in any cell not in column A)

If the headers can contain numbers (including dates):
=sum(a:a)-sum(a1:a3)

 

[Shane Devenshire]

Hi,

If the first three rows contain numeric data you can also use

=SUM(A4:A10000)

or whatever large number you want up to the number of rows in Excel.