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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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?
> >
> >
> >