=AVERAGEIFS(PendSold!F$2:$F$2145,PendSold!$C$2:$C$ 2145,"sold",PendSold!$A$2:$A$2145,$Z$9&"*")

Sorry, I did not send enough information. Here is my Average formula and I
need to change it to a Median formula.
Thanks,
Trev

"Luke M" wrote:

Try this array** formula:

=AVERAGE(IF(C1:C100="sold",B1:B100))

Adjust ranges as necessary.

**Array formulas must be confirmed using Ctrl+Shift+Enter, not just Enter.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trev" wrote:

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