If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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)) |
#2
|
|||
|
|||
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)) |
#3
|
|||
|
|||
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)) |
Thread Tools | |
Display Modes | |
|
|