Home |
Search |
Today's Posts |
#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
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring back the old help format! | Excel Worksheet Functions | |||
Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
Outlook 2003 demo back to Outlook XP | Excel Discussion (Misc queries) | |||
Roll back to previous date | Excel Worksheet Functions |