Thread
:
Bring Back Qualified Sum from another WB
View Single Post
#
2
Don Guillett
Posts: n/a
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 With Quote