=SUMPRODUCT(--([WBA.xls]Sheet1!A1:A1000="John
Doe"),[WBA.xls]Sheet1!K1:K1000)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ashlynn Grace" wrote in message
...
I really wish that I could use the SUMIF .... but doesn't that require
that
both workbooks be open? I want this to work whether or not both are open.
I
was told that SUMPRODUCT works to do this over SUMIF... I may be wrong.
Can
I just translate that SUMIF statement over to the SUMPRODUCT, or do I need
to
change anything?
--
---------------------------------------------
Thanks!


"Ardus Petus" wrote:

The operation you describe is doable with simple a SUMIF:
=SUMIF([WBA.xls]Sheet1!A:A,"John Doe",[WBA.xls]Sheet1!K:K)

Cheers
--
AP

"Ashlynn Grace" a écrit dans le
message de news: ...
Hi. I am having issues with learning the idea behind the SUMPRODUCT
formula
instead of the SUMIF, as I do not want to have both workbooks open. I
have 2
workbooks, lets name them Workbook A and Workbook B, where Workbook A
is
my
information and Workbook B is more like a report pulling info from WB
A.
I
want the SUMPRODUCT to search through WB A in column A for a certain
name,
and then search column K for any amount of money entered (by a formula
from
other cells) for that person. The only problem is, it may have
multiple
entries for each person that need to be added together to get this
final
number... to be placed in column C of WB B.
So, for example, if WB A has "John Doe" as the name in column A and 4
entries for his name, there are 4 amounts in column K associated with
his
name to be added together and placed in cell C4 of WB B.

How can I get this to operate smoothly? The amounts will vary each
month
as
there are different numbers of entries and amounts within the entries
each
month.

I know this is a lot to chew, but any pointers to push me in the right
direction would be wonderful!!

---------------------------------------------
Thanks!