Reference Cells from other Workbook to complete Formula

[Guest]

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.

 

[Peo Sjoblom]

Why doesn't it work?

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

works fine for me

 

[Guest]

I get a #VALUE! error. One time when I was messing with it I got a NAME
error. I'm not sure, but my only guess is that the [eBayActivityRep.xls]2QTR
TOTAL' cell is already calculating from two tabs in that workbook.
Suggestions?

Why doesn't it work?

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

works fine for me


--
Regards,

Peo Sjoblom

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.

 

[Guest]

I thin k I fixed my own problem, the previous workbook cell was set to an IF
formula that woulf default "" if there was no data. (I don't like making
things messy with a bunch of zeros) ONce I put an actual # in there, the
formula of the new workbook worked. Is there a way I can write a formula that
will populate using the current IF function?

I get a #VALUE! error. One time when I was messing with it I got a NAME
error. I'm not sure, but my only guess is that the [eBayActivityRep.xls]2QTR
TOTAL' cell is already calculating from two tabs in that workbook.
Suggestions?

Why doesn't it work?

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

works fine for me


--
Regards,

Peo Sjoblom

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.

 

[Guest]

I may have answered my ouwn question, the other workbook cell contains an IF
funciton that will defualt cell to "" if there is no calculation. ( i prefer
no "0" since it can tend to make things more messy). Once I popped actual
numbers in there, my original formula worked. Is there a formula that I can
write that will still populate with the existing IF formula of the other
workbook? I would prefer not to have a bunch of "0" around.

I get a #VALUE! error. One time when I was messing with it I got a NAME
error. I'm not sure, but my only guess is that the [eBayActivityRep.xls]2QTR
TOTAL' cell is already calculating from two tabs in that workbook.
Suggestions?

Why doesn't it work?

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

works fine for me


--
Regards,

Peo Sjoblom

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.

 

[Peo Sjoblom]

If you use the SUM function it will ignore text ("" blank is text)

=SUM('[eBayActivityRep.xls]2QTR TOTAL'!$B$2,'QTR 2 07'!B2)

should do it


--
Regards,

Peo Sjoblom

I thin k I fixed my own problem, the previous workbook cell was set to an
IF
formula that woulf default "" if there was no data. (I don't like making
things messy with a bunch of zeros) ONce I put an actual # in there, the
formula of the new workbook worked. Is there a way I can write a formula
that
will populate using the current IF function?

I get a #VALUE! error. One time when I was messing with it I got a NAME
error. I'm not sure, but my only guess is that the
[eBayActivityRep.xls]2QTR
TOTAL' cell is already calculating from two tabs in that workbook.
Suggestions?

Why doesn't it work?

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

works fine for me


--
Regards,

Peo Sjoblom


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.

 

[Guest]

Thanks Peo,
I had tried the SUM function before and my missing piece was having to use a
comma between the two numbers/criteria. Sometimes those little things get so
close...but not close enough. Thanks for taking the time.

If you use the SUM function it will ignore text ("" blank is text)

=SUM('[eBayActivityRep.xls]2QTR TOTAL'!$B$2,'QTR 2 07'!B2)

should do it


--
Regards,

Peo Sjoblom

I thin k I fixed my own problem, the previous workbook cell was set to an
IF
formula that woulf default "" if there was no data. (I don't like making
things messy with a bunch of zeros) ONce I put an actual # in there, the
formula of the new workbook worked. Is there a way I can write a formula
that
will populate using the current IF function?

I get a #VALUE! error. One time when I was messing with it I got a NAME
error. I'm not sure, but my only guess is that the
[eBayActivityRep.xls]2QTR
TOTAL' cell is already calculating from two tabs in that workbook.
Suggestions?

:

Why doesn't it work?

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

works fine for me


--
Regards,

Peo Sjoblom


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.