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.

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.

It worked - many thanks

Kate