I have 5 columns of data:
A holds a date
B holds a dollar value
C holds another dollar value.
D holds is the sum of B and C
E holds a running total of D
so a sheet may look like this.

B C D E F
04/01 1.00 .50 1.50 1.50
04/02 2.00 1.00 3.50 5.00
04/03 5.00
04/04 1.00 1.00 2.00 7.00
and so on
Total 4.00 2.50 7.00 7.00
the last row shows a total of each column. except E
What I am looking to do is :
in E on the total line just show the last number.
I am able to do this now with this formula
"=LOOKUP(2,1/(F6:F36<0),F6:F36)"
however each blank row shows numbers That I do not want to show. Look at
04/03.
The formula in F is "f6+e7"
Also on the total row if no numbers appear above in F it gives me and N/A I
would like to show a 0.

I know I was able to do this a few years ago but can not find my notes on
how to accomplish it.

Please help.