Finding last cell with a value and then adding to another

Finding last cell with a value and then adding to another

Post by S29vbHlIaW » Fri, 29 Aug 2008 04:58:08


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

Finding last cell with a value and then adding to another

Post by Gord Dibbe » Fri, 29 Aug 2008 06:48:37

=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

 
 
 

Finding last cell with a value and then adding to another

Post by S29vbHlIaW » Sat, 30 Aug 2008 01:48:04

Thank you so much, it worked like a charm.