Adding Columns

  • Thread starter Thread starter SPowell
  • Start date Start date
S

SPowell

Hi

I have several columns of data I need to sum individually,
the trick is I do not know how many numbers will be in
each column and I want the sumed(?) value displayed
somewhere else on the worksheet

Thanks
 
Hi
you could aleways use something like
=SUM(A:A)
as long as this formula does not reside in column A
 
Hi

i would create a dynamic range name for each of the columns you want to sum
and then in the sum formula use the name of the range rather than the cell
reference.

for example if your data is in sheet1, column A and starts at row 1
your range could be called
myrange
and in the (insert / name / define) refers to box type
=OFFSET(Sheet1!$A$1,0,0,Counta(Sheet1!$A:$A),1)

then when you want the total type
=SUM(myrange)

check out Debra Dalgleish's site (www.contextures.com/tiptech.html) for
details on creating dynamic range names.

Regards
JulieD
 
Back
Top