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

=SUM(A1:A10) entered in A11

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


Gord Dibben MS Excel MVP

On Wed, 23 Jul 2008 17:01:00 -0700, maria2008
<(E-Mail Removed)> wrote:

>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

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" <(E-Mail Removed)> wrote in message
news3E01D8A-746A-4A93-A881-(E-Mail Removed)...
>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
>