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