Summing numbers in a column with different lengths
I have a long spreadsheet with a series of numbers I need to sum. I know the start cell number i.e. (r, "D") and the end cell number (s,"D"). I need to sum from r to s and then go on to the next r to s and continuing to sum to the end of the spreadsheet. I am using a macro to find r and s, Thanks for the help
The sample macro would help and a sample workbook. Do you need to use VBA?, you could have a worksheet formula.
Not all forums are the same - seek and you shall find
You could use this: =SUM(OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)) and change the column letters for the column(s) that you want to sum....etc
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks