If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bring Back Qualified Sum from another WB
I'm in WB Main.xls with 4100 as text in cell D6;
I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls, without Success.. Can someone assist? TIA, =SUM(([Feb2005Deposits.xls]DepositsForMonth! $G$6:$G$3561="Reg")*([Feb2005Deposits.xls]DepositsForMonth! $K$6:$K$3561=$D6)*([Feb2005Deposits.xls]DepositsForMonth! $C$6:$C$3561)) |
#2
|
|||
|
|||
Did you array enter with ctrl+shift+enter vs just enter.
or use sumproduct((instead non-array entered -- Don Guillett SalesAid Software wrote in message ... I'm in WB Main.xls with 4100 as text in cell D6; I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls, without Success.. Can someone assist? TIA, =SUM(([Feb2005Deposits.xls]DepositsForMonth! $G$6:$G$3561="Reg")*([Feb2005Deposits.xls]DepositsForMonth! $K$6:$K$3561=$D6)*([Feb2005Deposits.xls]DepositsForMonth! $C$6:$C$3561)) |
#3
|
|||
|
|||
Thanks Don for your reply, Both WBs are "SHARED" and
perhaps that is why the several times I tried entering the below with Ctr-Shft_Enter nothing worked (the {}'s didn't take. I just made the formula-based WB "Exclusive", was able to complete the C-S-E (so it now shows the { } 's -- but still "no cigar"; From the formula (before) does it look like I am breaking any of the "rules" of excel? Tks again, Jim May -----Original Message----- Did you array enter with ctrl+shift+enter vs just enter. or use sumproduct((instead non-array entered -- Don Guillett SalesAid Software wrote in message ... I'm in WB Main.xls with 4100 as text in cell D6; I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls, without Success.. Can someone assist? TIA, =SUM(([Feb2005Deposits.xls]DepositsForMonth! $G$6:$G$3561="Reg")*([Feb2005Deposits.xls] DepositsForMonth! $K$6:$K$3561=$D6)*([Feb2005Deposits.xls] DepositsForMonth! $C$6:$C$3561)) . |
#4
|
|||
|
|||
After banging on this thing for an hour or two I finally
re-entered the below formula -- entering the ='S:\acct\acctgp\ the full path to my Feb2005Deposits.xls file. I got it going after that. Thanks for your input. wrote in message ... Thanks Don for your reply, Both WBs are "SHARED" and perhaps that is why the several times I tried entering the below with Ctr-Shft_Enter nothing worked (the {}'s didn't take. I just made the formula-based WB "Exclusive", was able to complete the C-S-E (so it now shows the { } 's -- but still "no cigar"; From the formula (before) does it look like I am breaking any of the "rules" of excel? Tks again, Jim May -----Original Message----- Did you array enter with ctrl+shift+enter vs just enter. or use sumproduct((instead non-array entered -- Don Guillett SalesAid Software wrote in message ... I'm in WB Main.xls with 4100 as text in cell D6; I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls, without Success.. Can someone assist? TIA, =SUM(([Feb2005Deposits.xls]DepositsForMonth! $G$6:$G$3561="Reg")*([Feb2005Deposits.xls] DepositsForMonth! $K$6:$K$3561=$D6)*([Feb2005Deposits.xls] DepositsForMonth! $C$6:$C$3561)) . |
#5
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I adore Microsoft PhotoDraw, and I hope you will bring it back. | kulakai | General Discussions | 0 | March 2nd, 2005 06:53 AM |
how do I have my returned e-mails not come back to my inbox with . | John Lancia | Database Design | 1 | February 17th, 2005 08:40 AM |
Bring back 30-day calendars and Task list display (2000/XP view) . | Ken Nowack | Calendar | 1 | December 20th, 2004 07:15 PM |
Bring back NetFolders for Outlook so I can synch with other users. | NetFolders fan | Contacts | 1 | November 17th, 2004 02:10 PM |
Bring back Netfolders! | shealy | Contacts | 1 | October 15th, 2004 06:21 PM |