Sum varying number of rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Possibly, but the problem is where would the formula go, since I don't know
how many rows there will be?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine number of rows with data 6
Macro for Varying Number of Rows 0
Sort on 3 columns when number of rows vary daily 1
Code to Resize a variable number of rows including target 7
Sum columns of data in vba 2
AutoFill down a certain number of rows 3
Macro that sums cells in rows of varible number and.... 2
Copy columns and paste with blank column between 5

Back
Top