referencing data in different workbook
Posted by itgirl168 on September 24, 2001 11:10 AM
I have two workbooks. I would like a cell in workbook A to equal the sum of a range of cells found in workbook B. I have tried hightlighting the cell in workbook A and typing in '=SUM' and then highlighting the cells that I want to add up on workbook B. The formula comes up as:
=SUM+'[TicketAging.xls]Ticket Aging Information'!$I$15:$I$42
However, when I hit enter, I get the error message: The text you enetered is not a valid reference or defined name.
What am I missing here?
Any help would be much appreciated!