| Home |
| Search |
| Today's Posts |
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| Sumif range returns #NUM! | Excel Worksheet Functions | |||
| SUMIF across a range of worksheets | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
