Thank you all. I used the solution from Ashish as that was the shortest.

Jan

wrote:
I have a spreadsheet:

Price Status
100
120 Sold
115 Sold
130
140 Sold

Now I try to find the seocnd larges amout something is sold for. I
have tried something like

=SUMPRODUCT((B2:B6="Sold")*(A2:A6=LARGE(A2:A6;2))* (A2:A6)

or

=IF(C2:C15="solgt";LARGE(D2:D15;2))

entered as an array formula, but both (other attempts as well) returns
130 (the second highest price) where it should return120 (second
highes price, sold).

Any suggestions?

Jan