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",...) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM multiple criteria
With data arrange as below; try this formula
=SUMPRODUCT(SUMIF(A1:A5,"*" & C1:C2 & "*",B1:B5)) Col A Col B Col C apple 1 app apple 2 ora orange 3 mango 4 mango 5 If this post helps click Yes --------------- Jacob Skaria "modene1" wrote: 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",...) |
Reply |
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 |