Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with n conditions
Suppose a have a definition table with the following conditions
StatusToSum - The number of conditions to sum is variable, having up to N (< 10) Won Lost In the main table a have two colunms with more than 4000 rows Status Price Won 456 Cancelled 798 Lost 547 Lost 847 Negotiating 748 I want to sum the Price of all rows that match any of the conditions. I tried something like the following array formula but the ranges don`t have the same size so i returns a error {=SUM((Status=StatusToSum)*Price))} The following sums everything =SUM(IF(OR(TRANSPOSE(StatusToSum)=Status);Price)) Don't want to name the several conditions like {=SUM(((Status=StatusToSum1)+.........+(Status=Sta tusToSumN))*Price))} Any clever ideia? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with several, 10, conditions | Excel Discussion (Misc queries) | |||
Sumif with two conditions? | Excel Worksheet Functions | |||
Using Sumif with 2 conditions | Excel Worksheet Functions | |||
Sumif with 2 conditions | Excel Discussion (Misc queries) | |||
sumif with 3 conditions | Excel Worksheet Functions |