Finding last cell with a value and then adding to another

K

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))
 
G

Gord Dibben

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

Where cellref is "another cell"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top