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

Did you array enter with ctrl+shift+enter vs just enter.
or
use sumproduct((instead
non-array entered

--
Don Guillett
SalesAid Software
[email protected]
<[email protected]> wrote in message
news:[email protected]...
> 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
>[email protected]
><[email protected]> wrote in message
>news:[email protected]...
>> 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.

<[email protected]> wrote in message
news:[email protected]...
> 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
> >[email protected]
> ><[email protected]> wrote in message
> >news:[email protected]...
> >> 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))
> >>
> >
> >
> >.
> >

Glad I was able to provide a little help

--
Don Guillett
SalesAid Software
[email protected]
"Jim May" <[email protected]> wrote in message news:Gvi5e.27$ka3.10@lakeread02...
> 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.
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> > >[email protected]
> > ><[email protected]> wrote in message
> > >news:[email protected]...
> > >> 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))
> > >>
> > >
> > >
> > >.
> > >
>
>