SUMPRODUCT

[Poonam Desai]

Client.xls contains
Material Quantity

ASDF 25
LKJH 12
ASDF 30
CVBN 14


Report.xls is linked with Client.xls

In report.xls i want to have a cell where in if i enter
ASDF it should total up the Quantities of ASDF sold in the
next cell same coloumn. IE: 25+30= 55.
ASDF can occur more than once.
I did this using DSUM, but it wont work if Cleint.xls is
not open and active. I read somewhere on google that in
such conditions sumproduct works. I did my R&D but cant
make this work. Please hint.

Thanks for your time.
-Poonam

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--('D:\My Folder\[Client.xls]My
Sheet'!$A$2:$A$500=Criteria),'D:\My Folder\[Client.xls]My
Sheet'!$B$2:$B$500)

where Criteria is a named cell where put the name you want the SUM for

adapt accordingly

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)