| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding and Adding | Excel Worksheet Functions | |||
| finding last non-blank cell and then copying it to the next cell | Excel Discussion (Misc queries) | |||
| Finding Corresponding Cell Value | Excel Discussion (Misc queries) | |||
| Finding a value by adding certain sums in a range? | Excel Discussion (Misc queries) | |||
| Finding a match and adding to the statement | Excel Discussion (Misc queries) | |||
Hybrid Mode
