How to sum a column of unspecified length?

Microsoft Microsoft excel 2007 full vers...
December 13, 2011 at 07:45:27
Specs: Windows XP
In column A, I have the following data: 2, 2, x, 2, b, 3, 4, 5. A total of 8 rows of data. The first data can be in any row, I mean the starting row will vary. Now I want to insert 3 rows after the ‘b’ and place the sum of all data above it directly below the ‘b’. In this brief example, the total would be 6. The macro cannot be column specific as the data will not always be in column A. Further, the macro cannot be row specific since data can start at any row and I may want to add just the first row or add the first 25 rows. This macro was exceptionally easy in the spreadsheet I was using but in Excel, I can’t begin to write the necessary code. Any help is greatly appreciated.

See More: How to sum a column of unspecified length?

Report •

#1
December 13, 2011 at 11:39:23
re: "This macro was exceptionally easy in the spreadsheet I was using but in Excel, I can’t begin to write the necessary code."

What macro are you talking about?

What spreadsheet were you using?

How did the other macro work?

How did it know about all of the variables (row, column, number of cells, etc) that it needed? Did it ask you a series of questions?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question