ExcelBanter - Bring Back Qualified Sum from another WB

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Bring Back Qualified Sum from another WB (https://www.excelbanter.com/excel-worksheet-functions/20997-bring-back-qualified-sum-another-wb.html)

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))

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))

.

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))

.