| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM USING MULTIPLE CRITERIA
I want to add data in one column after evaluating criteria in 2 separate
columns. I have tried arrays and nested functions but can't figure it out. Any ideas? Please see example below. Cust Prod Code Loc On Order B W TNC 300 A Y VBN 2000 A Y VBN 500 A Z AOK 1000 Calculate sum of "On Order" based on 2 criteria - "Prod Code" and "Loc" Example: Criteria: Prod Code="Y" and Loc="VBN". On Order=2500. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
