would this help (array-entered):

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


On 25 Lut, 09:39, 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