sum entire column with heading rows

  • Thread starter Thread starter hsg
  • Start date Start date
H

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
 
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)
 
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.
 
Back
Top