| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Cells from other Workbook to complete Formula
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Cells from other Workbook to complete Formula
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Cells from other Workbook to complete Formula
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? "Peo Sjoblom" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Cells from other Workbook to complete Formula
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? "Dvinechild" wrote: 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? "Peo Sjoblom" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Cells from other Workbook to complete Formula
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. "Dvinechild" wrote: 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? "Peo Sjoblom" wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Cells from other Workbook to complete Formula
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 "Dvinechild" wrote in message ... 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? "Dvinechild" wrote: 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? "Peo Sjoblom" wrote: 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Cells from other Workbook to complete Formula
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. "Peo Sjoblom" wrote: 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 "Dvinechild" wrote in message ... 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? "Dvinechild" wrote: 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? "Peo Sjoblom" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| workbook/cell reference w/ formula | Excel Worksheet Functions | |||
| I have to change a bunch of formula that need to reference a different workbook. | Excel Worksheet Functions | |||
| Can references to cells be used as part of a workbook reference | Excel Discussion (Misc queries) | |||
| same date and set up on complete workbook | New Users to Excel | |||
| Designating a workbook reference base on a cells contents | Excel Worksheet Functions | |||
Linear Mode
