Here's how you add the ISNA to trap the error:

=IF(ISNA(SUMPRODUCT(--(Sheet2!$A$1:$A$5=Sheet1!A1),--(Sheet2!$B$1:$B$5)+(Sheet2!$C$1:$C$5))),"",SUMPROD UCT(--(Sheet2!$A$1:$A$5=Sheet1!A1),--(Sheet2!$B$1:$B$5)+(Sheet2!$C$1:$C$5)))

H.T.H.
--
when u change the way u look @ things, the things u look at change.


"Gregory Day" wrote:

THANK YOU! That makes sense. Now, it just returns #NA. I am trying to
incorporate ISNA in to the formula you provided, but can't seem to make it
work.

Any suggestions on that?

-Thanks again.

"sahafi" wrote:

Try this version of SUMPRODUCT:

=SUMPRODUCT(--(Sheet2!$A$1:$A$5=Sheet1!A1),--(Sheet2!$B$1:$B$5)+(Sheet2!$C$1:$C$5))
Assuming the data is in Sheet2 A1:C5 and the formula goes into Sheet2 per
your request.

H.T.H.
--
when u change the way u look @ things, the things u look at change.


"Gregory Day" wrote:

I have a sheet containing 3 columns. The first column is a name, the second
and third are numbers. I would like to have a foumula that will look down the
list for each occurance of a specific name, and upon finding it, add the
contents of column 2 and 3 on that row to a running total for all of the
occurances found. Ex:ample:

| 1 | 2 | 3
----------------------------------
A | Gregory Day | 2 | 2
B | Gregory Day | 2 | 2
C | Gregory Day | 2 | 2

Should return an answer of 12.

Does that make sense? The only additional question is that the formula would
be a sheet 1, the data on sheet 2.

I have tried, SUM, SUMPRODUCT, COUNT, COUNTIF, AVERAGE and combinations
there of, with out luck. Any help would be greatly appreciated.

Thank you,