Advance Filter to filter the unique status
you will have
In C2: Won
In C3: Lost
In C4: Negotiating
....

In D2: =SUMIF($A$2:$A$100,"C1",$B$1:$B$100)

Drag the Fill Handle in D2 down as far as needed



"Caio Milani" wrote:

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?