Thread: Finding last cell with a value and then adding to another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KoolyHigh KoolyHigh is offline
external usenet poster
  
Posts: 2
Default 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))


Reply With QuoteReply With Quote