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!