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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks