Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two colunms | Excel Worksheet Functions | |||
If function to match colunms | Excel Discussion (Misc queries) | |||
Matching data in multiple colunms | Excel Discussion (Misc queries) | |||
Comparison of data in two separate colunms | Excel Discussion (Misc queries) | |||
COUNTIF with two colunms | Excel Programming |