index match and sum

[Pamela]

Hello All,
I have a listing of product orders in a workbook. In another workbook I
want to find the product, and sum the quantity of orders I have for each
product. I have the index/match down, but it only returns the first value,
I need it to go through the range and sum all the values.
Here's an example of what I have, any help or hints would be appreciated.

=if(iserror(match($a2,Orders!J:J,0)),"0",index(Orders!I:I,match($a2,Orders!J
:J,0)))
Thanks
Pam

 

[Myrna Larson]

Use COUNTIF. It's documented in Help. If you need the total value of those
orders and you have a column with the order total, it would be SUMIF. Again,
see Help.

 

[Jason Morin]

=SUMIF(Orders!J:J,$A2,Orders!I:I)

HTH
Jason
Atlanta, GA

 

[Pamela]

Thanks,
That works!
Pam

Use COUNTIF. It's documented in Help. If you need the total value of those
orders and you have a column with the order total, it would be SUMIF. Again,
see Help.



J

 

[Pamela]

I take that back, The SUMIF works, but it brings over the wrong totals, I
have retyped the partnumbers so I know it is matching correctly, but it is
dropping some and adding some other places, could you look at this formula
and tell me what I could have done wrong?
=SUMIF(Orders!$I:$I,MATCH($a3,Orders!$J:$J,0))
Thanks
Pam
"Myrna Larson"

 

[Pamela]

Thank You So Much!!! Myrna, Ignore the question that will be popping up,
this answers it.
Thanks Again to both of you.
Pamela