nesting functions

  • Thread starter Thread starter SteveDB1
  • Start date Start date
S

SteveDB1

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.
 
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)
 
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.
 
Back
Top