CODEWITHSUNDEEP
excelindexingsum
k.troy2012
k.troy2012

Reputation: 344

Excel: Get index of THIS cell - 1

I've built a php tool which grabs data from a database and creates an excel sheet like this.

enter image description here

I want to sum up all durations. I cant use "=SUM(F2:F7)" in F8 because every new sheet has a different amount of rows.

I need something like this in F8: "=SUM(F2:INDEX.OF.THIS.CELL-1)"

Thanks.

Upvotes: 1

Views: 433

Answers (1)

Vinnie
Vinnie

Reputation: 553

Try this:

=SUM(INDIRECT("F2:F" & ROW()-1))

Upvotes: 1

Related Questions