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

=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

Where cellref is "another cell"

Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 12:58:08 -0700, KoolyHigh

Thank you so much, it worked like a charm.

1. Finding last cell to contain same value as current cell?

2. Add cell value to another worksheet cell using Find and offset

3. VBA: Add cell value to another worksheet cell using Find and offse

4. VBA: Add cell value to another worksheet cell using Find and offset

5. Finding the Value (of text and numbers) between N/A's

6. Finding the Value in a Last-Filled Column-Cell

7. Finding value in the last cell in column A

8. Can I find the last value in a column of cells?

9. finding last value in range of cells

10. Find Cell with Value and get Value of Cell Below it

11. Find second to last value in cell

12. FIND CELL VALUE THEN INCREASE THE VALUE OF THE ADJACENT CELL

13. Compare value in cell A to value in Cell b and add 1

14. macro- keep value in cell and add value for adjacent cell

15. How do I add up the last 12 cells (containing values) in a col

3 post • Page:**1** of **1**