P
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
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