nesting functions
 

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.

nesting functions
 

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.

nesting functions
 

Thanks T.
Unfortunately, that doesn't get what I'm looking for. Sumif is what I was
using before I was introduced to Sumproduct.

Perhaps I've just overthought this.... I'l keep working with it, and see
what I come up with to repost if needed.
Again, thank you for your time.


"T. Valko" wrote:

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.

nesting functions
 

Post a small sample of your data and tell us what result you expect.

--
Biff
Microsoft Excel MVP


"SteveDB1" wrote in message
...
Thanks T.
Unfortunately, that doesn't get what I'm looking for. Sumif is what I was
using before I was introduced to Sumproduct.

Perhaps I've just overthought this.... I'l keep working with it, and see
what I come up with to repost if needed.
Again, thank you for your time.


"T. Valko" wrote:

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.