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

"maria2008" wrote in message
...
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