SUMPRODUCT is good when there are multiple criteria. If there's just a
single criteria use SUMIF:

A1 = some name

=SUMIF(Sheet2!A1:A100,A1,Sheet2!B1:B100)

--
Biff
Microsoft Excel MVP


"SteveDB1" wrote in message
...
morning all.
I think that I need to nest some worksheet functions that will allow me to
test data between two worksheets.

I need to look through a range of cells on my destination page to match a
name on my source page.
Once I find that name, I want to tally numeric values in an adjacent
column
that are on the same row as that name.

My initial thoughts would be the use of sumproduct, and an if statement,
but
I've never used sumproduct in that manner before-- successfully.

Normally, when I use sumproduct, I test two criteria, and sum the total
values based on those criteria. It took some time, but I got all the bugs
I'd
found worked out, and I use sumproduct in one specific manner now
constantly.

Here, I just want to compare the values from my source page, with a range
on
my destination page.
If you need more clarification, please ask.
Thank you.