| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and grouping data with varying number or rows | Excel Worksheet Functions | |||
| How do I make a chart take into account a varying number of rows? | Charts and Charting in Excel | |||
| SUMPRODUCT with varying # of rows | Excel Worksheet Functions | |||
| Transfer rows with varying criteria | Excel Programming | |||
| Using a Macro to perform a VLookup on varying number of rows | Excel Programming | |||
Hybrid Mode
