| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have two columns (A) and (G) that have like product codes however | Excel Worksheet Functions | |||
| sum and product, but not sumproduct? | Excel Worksheet Functions | |||
| Excel 2003 list of field codes for footers? | Excel Discussion (Misc queries) | |||
| Using PRODUCT in Calculated Field | Excel Discussion (Misc queries) | |||
| Word field codes in Excel data file Includetext | Excel Discussion (Misc queries) | |||
Threaded Mode
