reference cell in another workbook

[jobdillon]

Using Excel 2010, when I open a summary workbook that contains references to other workbooks in the same folder and click "update links", I receive a #VALUE error message in each cell with a reference. My formulas are similar to the following:

Please Login or Register  to view this content.

I created the formula by opening both the summary workbook and the referenced workbook, entering the formula name in the cell in the summary workbook, selecting the cells in the referenced workbook, completing the formula and then closing the referenced workbook.

The summary workbook will be viewed by other users and I don't want them to have to open each referenced workbook in order to view the contents.

[aworfolk]

try this make sure to push cuntrol shift enter and not enter to activate the formaula

Please Login or Register  to view this content.

[jobdillon]

Thank you! This works fine. I really appreciate the time that you took for your reply. So, all I need to do to reference cells in another workbook is to <Ctrl><Shift><Enter>, rather than just <Enter> after I select the cells.

[aworfolk]

Yes but you can not do countif or sumif if you whant the other workbook closed do Count (IF(.

[jobdillon]

However, COUNT(IF(... does not give me the correct answer. This gives me the number for all of the rows, not just the ones with the "yes" value.

[aworfolk]

Ok Try This GAve me the number of cells that had Yes in it, It is the same code just the Count is changed with Sum.

Please Login or Register  to view this content.

It is a array so make sure to hit CRTL Shiift Enter.

[jobdillon]

Thanks - this is just what I needed.