adding data from two colunms

[maria2008]

I hope you can help me with this.
I have two columns one estimated cost the other actual cost

est cost actual
100 50
300
400
500

t 1300 total $$$
I would like the total under the actual colunm to use the est cost value if
the actual cost is not there, so that i have a running total of what i have
estimated and what has been already aquired.
thank you in advance

 

[Gord Dibben]

=SUM(A1:A10) entered in A11

=A11-SUM(B2:B10) entered in B11


Gord Dibben MS Excel MVP

 

[Skinman]

I could be wrong but the formula I think you require is
=SUMIF(actual,"",estcost)+SUM(actual)...
Enter in cell below the named range actual. You have to name the range
estcost and the range actual
Skinman if