| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum a column of variable length?
I have to build a workbook where columns of data will be cut and pasted into
Tab 1, then the column totals need to appear automatically on Tab 2. The problem is that the number of rows of data in Tab 1 will be variable and unpredictable, although the columns will always start in a known row. I might be able to do it by something like =SUM('Tab 1'!I7:I65535) but is there a more precise way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Finding intersection of row and column (both variable) in table | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Threaded Mode
