Why doesn't it work?

='[eBayActivityRep.xls]2QTR TOTAL'!$B$2+'QTR 2 07'!B2

works fine for me


--
Regards,

Peo Sjoblom


"Dvinechild" wrote in message
...
Hello,
I'm attempting to make a data sheet that requires a formula to pull from
another workbook, add a cell from a different tab, and plop the total into
my
final analysis tab. This may be primary, but this is what I have:

='[eBayActivityRep.xls]2QTR TOTAL'!$B$2+'QTR 2 07'!B2

Of course this doesn't work, and I've tried SUM, SUM/INDIRECT, etc. In
addition to the basic formula result, I'd like the anaylsis cell to
default
to "0" if there was no data to pull from for that day.

Your assistance or direction is helpful. It's a difficult topic to search.