sorry

=MEDIAN(IF(Sheet1!C1:C100="sold",Sheet1!B1:B100))

should be correct if yr data is in Sheet!B1:B100

adjust the ranges


On 3 Lis, 14:50, Jarek Kujawa wrote:
=MEDIAN(IF(Sheet1!C1:C100="sold",Sheet1!C1:C100))

array-entered i.e. CTRL+SHIFT+ENTER

On 3 Lis, 14:43, Trev wrote:



I need a formula that will give me median if Column C on Sheet 1 =sold. Any
ideas? *Thanks
Trev- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -