ExcelBanter - Finding last cell with a value and then adding to another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Finding last cell with a value and then adding to another (https://www.excelbanter.com/excel-worksheet-functions/200490-finding-last-cell-value-then-adding-another.html)

KoolyHigh

Finding last cell with a value and then adding to another

I need help in writing a formula that will lookup the last value in a column
and then add that value with the value in another cell where you have several
rows in between that are null.

A
1 10
2 14
3 =A1 + A2
4
5 IF(A4 = 0, "", A3 + A4)
6
7 IF(A6 = 0, "", A6 + A7)
8
9 =IF(A8=0,"",IF(A80, SUMIF(A7,"0",A7:A8), A5+A8))

Gord Dibben

Finding last cell with a value and then adding to another

=LOOKUP(99^99,A:A) + cellref

Where cellref is "another cell"

Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 12:58:08 -0700, KoolyHigh
wrote:

I need help in writing a formula that will lookup the last value in a column
and then add that value with the value in another cell where you have several
rows in between that are null.

A
1 10
2 14
3 =A1 + A2
4
5 IF(A4 = 0, "", A3 + A4)
6
7 IF(A6 = 0, "", A6 + A7)
8
9 =IF(A8=0,"",IF(A80, SUMIF(A7,"0",A7:A8), A5+A8))

KoolyHigh

Finding last cell with a value and then adding to another

Thank you so much, it worked like a charm.

"Gord Dibben" wrote:

=LOOKUP(99^99,A:A) + cellref

Where cellref is "another cell"

Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 12:58:08 -0700, KoolyHigh
wrote:

I need help in writing a formula that will lookup the last value in a column
and then add that value with the value in another cell where you have several
rows in between that are null.

A
1 10
2 14
3 =A1 + A2
4
5 IF(A4 = 0, "", A3 + A4)
6
7 IF(A6 = 0, "", A6 + A7)
8
9 =IF(A8=0,"",IF(A80, SUMIF(A7,"0",A7:A8), A5+A8))

All times are GMT +1. The time now is 07:28 AM.