Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM multiple criteria
Scenario:
Data: A B 1 x 100 2 y 150 3 z 200 4 a 50 5 6 ("x","a") I would like a formula that does something like: sum the values in column B if the values in column A equals ANY of the values in A6 i.e. A6 is a list or array of criteria. Partial criteria match would be great too e.g. A3 is replaced with "apple" and A6 contains (....,"ppl",...) |
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 |