adding data from two colunms
 

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

adding data from two colunms
 

=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
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

adding data from two colunms
 

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