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