Sum varying number of rows

I am pulling data into an excel spreadsheet from another application. The
number of rows can vary each time the program is run. How can I add column
totals without hard-coding in the cell ranges?

Can you use complete columns, it is the simplest way

=SUM(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LSkarbek" <LSkarbek@discussions.microsoft.com> wrote in message
news:496710D1-BE8D-464E-B6ED-5D47FC85375F@microsoft.com...
> I am pulling data into an excel spreadsheet from another application. The
> number of rows can vary each time the program is run. How can I add
column
> totals without hard-coding in the cell ranges?

Possibly, but the problem is where would the formula go, since I don't know
how many rows there will be?

"Bob Phillips" wrote:

> Can you use complete columns, it is the simplest way
>
> =SUM(A:A)
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "LSkarbek" <LSkarbek@discussions.microsoft.com> wrote in message
> news:496710D1-BE8D-464E-B6ED-5D47FC85375F@microsoft.com...
> > I am pulling data into an excel spreadsheet from another application. The
> > number of rows can vary each time the program is run. How can I add
> column
> > totals without hard-coding in the cell ranges?
>
>
>

If you have to work out where the formula goes, then that is visual, so
using Autosum should be perfectly adequate shouldn't it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"LSkarbek" <LSkarbek@discussions.microsoft.com> wrote in message
news:6D3AB874-1FEE-4682-BFAF-62196F333FB2@microsoft.com...
> Possibly, but the problem is where would the formula go, since I don't
know
> how many rows there will be?
>
> "Bob Phillips" wrote:
>
> > Can you use complete columns, it is the simplest way
> >
> > =SUM(A:A)
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "LSkarbek" <LSkarbek@discussions.microsoft.com> wrote in message
> > news:496710D1-BE8D-464E-B6ED-5D47FC85375F@microsoft.com...
> > > I am pulling data into an excel spreadsheet from another application.
The
> > > number of rows can vary each time the program is run. How can I add
> > column
> > > totals without hard-coding in the cell ranges?
> >
> >
> >