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?

Sum varying number of rows
 

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" wrote in message
...
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?

Sum varying number of rows
 

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" wrote in message
...
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?

Sum varying number of rows
 

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" wrote in message
...
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" wrote in message
...
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?