Finding last cell with a value and then adding to another

[KoolyHigh]

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(A8>0, SUMIF(A7,">0",A7:A8), A5+A8))

 

[Gord Dibben]

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

Where cellref is "another cell"


Gord Dibben MS Excel MVP

 

[KoolyHigh]

Thank you so much, it worked like a charm.

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

Where cellref is "another cell"


Gord Dibben MS Excel MVP