Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding values from different workbook
I have 2 workbooks; an Invoice Register (for all jobs and phases) and a
Project Cost Control workbook. I need to search the entire Invoice Register finding and adding values based on job name, phase code AND whether or not paid ("X"). I then need to add all the paid invoices for that job and phase code and bring that number into the Project Cost Control sheet for that phase and job. I have been using a sumproduct formula that has worked but with intermittent errors. Now it isn't working at all. I think perhaps the errors were caused by Blanks in the Invoice register? Could that be correct? I didn't get an error but I got wrong amounts in some places. Anyhow, I'd like to construct the formula properly so that i can trust the results. I'm using Excel 2003. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a chart to large workbook brings workbook activity to a hal | Excel Discussion (Misc queries) | |||
Adding Values | Excel Worksheet Functions | |||
How do I call number values form one workbook to another workbook | Excel Worksheet Functions | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
adding name values | Excel Worksheet Functions |