If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sumif range of varying size
how do I sum a column which always starts in the same place but the end row
varies? I have the row number of the end row held elsewhere in the spreadsheet but don't know how to incorporate it into the sumif formula. |
#2
|
|||
|
|||
One way
=SUM($A$1:INDEX(A:A,D1)) where A1 is the first row and D1 holds the last row number -- Regards, Peo Sjoblom "KM01" wrote in message ... how do I sum a column which always starts in the same place but the end row varies? I have the row number of the end row held elsewhere in the spreadsheet but don't know how to incorporate it into the sumif formula. |
#3
|
|||
|
|||
It worked - many thanks
Kate |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Oscar | Worksheet Functions | 2 | January 11th, 2005 11:01 PM |
Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
Need help on changing text size | Luke Sineath | Page Layout | 7 | June 11th, 2004 05:53 AM |