All geek questions in one place

Excel links from fixed cell to end of column?

I want to make an excel formula that calculates the SUM of an entire column, starting from a specific cell to the end of the column: SUM from S5 to the last S-cell ... I tried: SUM(S5:S) but does not work

In fact, I have a worksheet template that contains some lines at the beginning, every time I copy this template and I duplicate the last line and fill it with different data ... That's why I want to make a general formula that applies to all cases ...

PS: I have a cell that contains the number of rows, can I, for example, use a variable in Excel Formula:

 SUM(S5:S & A1)

With A1 containing the number of rows?

Anyone have an idea plz?

+6
source share
2 answers

You can try =SUM(OFFSET(S5,0,0,ROWS(S:S)-ROW(S5)+1))

+7
source

To sum all cells from A2 to the end of column A, you can use

 =SUM(A2,INDIRECT("A2:A" & ROWS(A:A)))

This will work even if you put it in cell A1.

+1
source

Source: https://habr.com/ru/post/913541/

More articles:


All Articles