View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tan tan is offline
external usenet poster
 
Posts: 29
Default Querying multiple Product Codes in one field using SUMPRODUCT()

Hi All,

I have a field named Product_Code in my database. Have another field called
country_code, and a last one named Shipment_Amt$.

My draft formula is:
=sumproduct(--(Product_code=B15), --(Country_code=$C$2))

How do i perfect my sumproduct formula to extract out multiple product
codes, look for a particular country code and sum up all the shipment amt?
Thanks...