Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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))

  #3   Report Post  
 
Posts: n/a
Default

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   Report Post  
Jim May
 
Posts: n/a
Default

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



.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bring back the old help format! John Przybylski Excel Worksheet Functions 2 April 5th 05 06:24 PM
Find a non-blank cell and bring back text a in same row Rod Excel Worksheet Functions 12 March 24th 05 10:43 PM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 09:11 AM
Outlook 2003 demo back to Outlook XP Pete Carr Excel Discussion (Misc queries) 1 December 22nd 04 09:04 AM
Roll back to previous date Jay Excel Worksheet Functions 2 December 3rd 04 04:35 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"