| 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. |
| 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 | |||
Threaded Mode
