add duplicated data

hi
i am using the following formula to extract data quantities of items from a worksheet:

HTML Code: 

is there any way i can modify it so that it adds the qtys of the items which have duplicated item nšs?
thanks

Hi,

using sumif maybe?

=SUMIF(OS_SALES_ORDERS,A9,OFFSET(OS_SALES_ORDERS,0,3))

However, if you could add further named ranges withing the OS_SALES_ORDERS range, the OFFSET function could be dispensed with, and the formula would make more "sense".

Without knowing exact content of defined name another variant would be:

=SUMIF(INDEX(OS_SALES_ORDERS,0,1),A9,INDEX(OS_SALES_ORDERS,0,3))

If the above also does not return expected output then please post a workbook...

(may also be worth considering a Pivot Table - intro. link in sig.)